Sorting in a Access Report

Posted on 2014-01-13
Medium Priority
Last Modified: 2014-01-13
I have a simple report that looks like
  C Smith
                  store           paygroup    paycompany  notes

The powers that be wish me to have the store numbers sorted by ascending. Fine. Now the want me to the the notes field which denotes "Closed" Put them at the bttom of the first store and have those in ascending order. I can get the stores in asceding order but when U try to do the second sort exeything is mix up
Question by:Serena2345
  • 2

Assisted Solution

mebaby333 earned 1000 total points
ID: 39776927
Have you tried to set the two fields next to each other? try moving the note field to the right of the store field

Accepted Solution

mebaby333 earned 1000 total points
ID: 39776939
Access I believe sorts from left to right so it will try to sort the columns in between...

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

622 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