Sorting on Part of a Field

[LQ]

Is it possible to sort a report on part of a field, such as the last three numbers of a medical record #? Can I enter some sort of expression in the sorting and grouping dialog box that will do this?

TIA

 

[Haytham]

Hi , of course you can.
Create a new unbound and choose which character to sort. e.g.
=Mid([MedicalRecord];11;3)
This will sort the last 3 characters of your Medical record.
HTH

 

[LQ]

You got me to thinking....I typed in
=Right([Medrec],3)
under Field/Expression in the grouping and sorting dialog box, and it seems to have worked. I guess I didn't realize you could do that!

Thanks for putting me on the right track!