CODEWITHSUNDEEP
sortingms-accessconcatenationms-query
user5544694
user5544694

Reputation:

How to sort a concatenated field in MS-Access 2013 Query

I have two concatenated fields in a ms-access query, The fields are: [FirstName] & " " & [LastName], and I want to sort them by last name. How do I sort them like this? Thanks.

Upvotes: 1

Views: 914

Answers (1)

David T. Macknet
David T. Macknet

Reputation: 3162

Include the [LastName] field in your query (but not shown) and then click the Sort drop-down and select Ascending (or Descending, if you like). Then sort on the [FirstName] or on the concatenated field. The order in which the sort is performed is left to right, in terms of the fields in the query builder, so you'd need to drag/drop appropriately.

Upvotes: 2

Related Questions