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.
 

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

Back
Top