Solved

Why wont the Phone List report sort by Last Name?

Posted on 2016-11-29
2
29 Views
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
Sort-by-Last-name.png
CustomerContactModernV6.accdb
0
Comment
Question by:cssc1
2 Comments
 
LVL 6

Accepted Solution

by:
Anders Ebro (Microsoft MVP) earned 500 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.
0
 

Author Closing Comment

by:cssc1
ID: 41906597
Works great, thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now