Concantenated Field Sort Order

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

Guest

Hi,

I have a text box with the following expression. =[FIRSTNAME] & " " &
[LASTNAME] & " " & [Degree]

I would like to sort by the Last Name field in the expression. How do I set
the Sorting and Grouping function to sort by LastName?

Thanks
 
What's wrong with setting the primary sorting and grouping level to
[LastName]? It appears that this field must be in your report's record
source.
 
Hi,

I have a text box with the following expression. =[FIRSTNAME] & " " &
[LASTNAME] & " " & [Degree]

I would like to sort by the Last Name field in the expression. How do I set
the Sorting and Grouping function to sort by LastName?

Thanks
Click to expand...

In the Report's Sorting and Grouping dialog enter the [LastName] field
in the top panel.

If you also want the sort to reflect the first Names, add [FirstName]
to the sorting and grouping dialog.
[LastName] Ascending
[FirstName] Ascending
 
Back
Top