Concantenated Field Sort Order

[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

 

[Duane Hookom]

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.

 

[fredg]

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

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