Report Alphabetizing By Non-Indexed Field

[JeffreyE]

I apologize in advance for this is a repeat question from several days ago. I have a report of a multi-table query that I would like to group by table 1's indexed field, medical record number, but sort (alphabetize) by the patient's last name. When I group and sort by last then first name, the one-to-many relationship of the index, medical record number, does not hold true with table 2's diagnoses with the same last name grouped under only the first of those patients (i.e. Betty and Carla Smith's diagnoses are group under Alice Smith's name.) The creation of an expression with both last and first name is better but is not accurate if two patients have the same last name. Any suggestions?

 

[PaulF]

try making an expression field on all 3 items

LastName & FirstName & Cstr(ID)


PaulF

 

[JeffreyE]

Thank you very much. I had to go back and learn more about expression building and tinker with where the expression should be placed but it now works very well. I built the expression into the query, created an invisible field in the report (because I already had the report spacings like I wanted them), and then sorted and grouped off of the expression (instead of ID or last name.)

Jeff Embrey