Report Alphabetizing By Non-Indexed Field

[JeffreyE]

I have a medical report that is based on a multi-table query. The primary table's index is a patient ID number. The patient ID number in the first table (Patients)is the one-to-many link to the second table (Pathology Cases). If I sort by this number, the report captures the correct diagnoses for each individual patient, but the order is by ID number and not patient last name. If I sort by last name then first name, the last names are properly alphabetized but all diagnoses for patients named Smith are listed under the Smith, Alice and all subsequent Smiths, Betty and Carl, are excluded. Have any suggestions? Thanks for your help in advance.

JeffreyE

 

[PaulF]

create an expression field for last name and first name and sort on this

PaulF

 

[JeffreyE]

I would like to keep the specificity of the indexed patient ID number in case I have two patients with the same first and last name, which happens quite often. Is it possible to "group" by the index patient ID number but "sort " alphabetically by last, then first name?