Double Sort By

  • Thread starter Thread starter Gary Dolliver
  • Start date Start date
G

Gary Dolliver

Hi all,
Is it possible to set up multiple sorts on a query and have it be
consistent? I have two columns I want to sort by, and I need to have column
A be the first sort and B be the second, or the data will not be correct. I
have tried using separate queries, but it seems to forget the first sort -
and then sometimes if I remove one sort it works, but does not work the next
time I run it. Is there some type of "first sort A then sort B" syntax?
Setting them both to sort ascending does not always result in the data I
need. Help is appreciated, thanks
-gary
 
Hi Gary,

When you create the query in the query builder, the sort order is left to
right so just place the fields across the matrix in the order required for
the sort and then set the sorts on the required fields.
 
Awesome, thank you

OssieMac said:
Hi Gary,

When you create the query in the query builder, the sort order is left to
right so just place the fields across the matrix in the order required for
the sort and then set the sorts on the required fields.
Click to expand...
 
Back
Top