Sorting in a Access Report

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
Serena2345Asked:
Who is Participating?
 
mebaby333Connect With a Mentor It AdminCommented:
Access I believe sorts from left to right so it will try to sort the columns in between...
0
 
mebaby333Connect With a Mentor It AdminCommented:
Have you tried to set the two fields next to each other? try moving the note field to the right of the store field
0
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.

All Courses

From novice to tech pro — start learning today.