Multiple sorts in Access 2000

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

Guest

Anyone know how to run multiple sorts on an Acess 2000 data table? I would
like to use a multiple sort as in Excel.
 
In a table? No.

Tables are used to store data. They are not user interfaces. In your
queries, reports, or forms, you can sort by multiple fields.

Rick B
 
You CAN sort by multiple fieds in a table, although as mentioned, this is
not common practice. To sort by multiple fields in a table, use your cursor
to select the fields headers of the columns you want to sort by. Then click
the A/Z button.

You'll need to make sure the fields you want to sort by are next to each
other. Access won't let you select fields separated by other fields. To
move a field temporarily for sorting, select the field header, then use drag
n drop to put it next to the other fields you wish to sort by. Hard to
explain in text :|

Hope that helps
 
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

Multiple Data Sorts in Access 2000 2
TABLE VIEW IN ACCESS 2000 2
Access Dcount (multiple criteria) 3
Access photo sorting into multiple catagories 1
Sorting multiple fields 1
sort two coloum in a Table 1
Multiple field sort 2
Voltage supply issue related to NUC PC Core i7 0

Back
Top