Sorting records from a select query ?

[TonyB]

If I have an access db with a table containing a date and another parameter
say a number benig read by oledb commands, can I send an sql select query
that will return all records matching that date, but in the ascending order
value of number field ? Is this something I can setup in the access design
view for the table or in the query ?

 

[John W. Vinson]

If I have an access db with a table containing a date and another parameter
say a number benig read by oledb commands, can I send an sql select query
that will return all records matching that date, but in the ascending order
value of number field ? Is this something I can setup in the access design
view for the table or in the query ?

In the Query design grid, you can put Criteria on one field (or two fields, or
64 fields), and you can put Ascending or Descending as the sort order for up
to ten fields; they are independent.