Sorting a Concatenated Text Box

K

Karen

I have a text box in the detail section of a report and I would like to sort
by the LastName part of the expression.
=[FIRSTNAME] & " " & [LASTNAME] & " " & [Degree]

Thanks in advance for any help.
 
F

fredg

I have a text box in the detail section of a report and I would like to sort
by the LastName part of the expression.
=[FIRSTNAME] & " " & [LASTNAME] & " " & [Degree]

Thanks in advance for any help.
Click to expand...

you must use the report's Sorting and Grouping dialog.
In Report Design View:
View + Sorting and Grouping.
Enter [LastName] as a Field/Expression in the dialog.
 
Top