Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #30879

    We have imported our patient data from Clinic Office 2005 to Clinic office v4.
    We give our patients a numerical code staring with 1. We have found that we are unable to use the sorting feature to sort patients in terms of the numerical code as Clinic office sorts in a strange way e.g. 1, 10, 100, 11, 111 etc. … What am I doing wrong??!!!


    Hi Teresa,

    Thanks for your question. There are actually TWO fields available in the Patient grid. One is called ‘Code’ and the other is called ‘Patient Code’. The difference is that ‘Code’ is the raw code for the patient while ‘Patient Code’ is the combination of the ‘Clinic Prefix + code’ and because of that is stored as a TEXT value (rather than a number) which is why the sorting appears to be incorrect.

    If you want to be able to sort the Patient Grid by code in numerical fashion, simply add the CODE field into the grid by clicking Grid Options (top right) then Show Column Customizer and then drag-and-drop the Code column to the grid. You can also remove the ‘Patient Code’ column by dragging-and-dropping the ‘Patient Column’ into the Customize box.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.