LQ
01-31-2002, 07:23 AM
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
TIA
|
View Full Version : Sorting on Part of a Field LQ 01-31-2002, 07:23 AM 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 01-31-2002, 08:05 AM 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 01-31-2002, 09:14 AM 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! |