Sorting a Concatenated Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top