how do I sort using multiple fields in Access

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
 
K

Klatuu

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.
 
Top