how do I sort using multiple fields in Access

  • Thread starter Thread starter Virekca
  • Start date Start date
V

Virekca

I am trying to pull information from a form using to fields. The Hearing Date
and the PreTrial date. I need the sort to give the names with the data from
these fields in a form
 
Use a query based on your table sorted that way, the ORDER BY clause should be:

ORDER BY [Hearing Date], [PreTrial date]

If you use the Query builder, just make sure the Hearing Date field is to
the left of the Pretrial Date field and pust Ascending in the Sort row for
each column.
 
Back
Top