Why wont the Phone List report sort by Last Name?

Posted on 2016-11-29
Medium Priority
Last Modified: 2017-01-17
I created a report called "Phone List".
I have tried the following to make the report sort ascending by last name but still not sorting:

1. Query to sort ascending
2. Sort function on the report

To see the report open application and click Reports > Phone List
Question by:cssc1
LVL 11

Accepted Solution

Anders Ebro (Microsoft MVP) earned 2000 total points
ID: 41906570
Any sorting you set in the query is overruled by the sorting in the report. Therefore sorting should always be done in the report.

In the report, you were sorting by ER_Name_Relation first, and THEN by Last name. If you move the LastName to be first sort criteria, I believe you will get what you want.

Author Closing Comment

ID: 41906597
Works great, thanks

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question