• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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
0
Serena2345
Asked:
Serena2345
  • 2
2 Solutions
 
mebaby333Commented:
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
 
mebaby333Commented:
Access I believe sorts from left to right so it will try to sort the columns in between...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now