Concatenate 2 field in a control source and sort by one field

[MrTickle]

Hi there

Hopefully this is a very simple question. I have a text box in a report bound by datasource as follows:

=[Guest Firstname] & " " & [Guest Lastname]

I want the results to be ordered by [Guest Lastname], but I am not sure of the syntax when using 'OrderBy' and nothing I have tried has worked.

Can anyone help please?

Thanks in advance!

 

[John Big Booty]

You should be able to do this easily with your query query in design view.

The SQL syntax can be found here

 

[boblarson]

The query would be the way it really should be done. But just for informational purposes you can create a field like that in the sorting and grouping of the report and sort on it. So you can use

=[Guest Firstname] & " " & [Guest Lastname]

just like this:

But the more efficient way is to concatenate in the query and then set the sort in the report.

 

[MrTickle]

Thank you Bob and John, this has sorted it. I concatenated at query level and sorted at report stage and all is looking great.

Thanks again!