multiple sortings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to have multiple sortings in a select query i know i can
do it in sql but can it be done in the query grid
 
Yes, the sort order is from left to right on the columns in the grid.
E.G. if column 1 is surname and column 2 is firstname then you can set both
columns to be sorted ascending. It will sort by surname first and then by
firstname
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Ranking based on Multiple Data Fields 10
Multi-select drop-down for a query (Access 2007) 9
Unexpected results when sorting multi-table query using toolbar button 5
Parameter Query multiple criteria help 6
Summing multiple fields 2
Empty results when sorting multi-table query using toolbar buttonOptions 7
sort options unavailable for column of data in query 2

Back
Top