SIMPLE QUESTION? SORTING A TABLE

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

Guest

I have a database with 1 table that I created for a user that has no
knowledge of Access other than opening up the database. I showed them how
to do a simple single sort within the table - However, we now need to do a
primary sort and a secondary sort. How can this be done simply within the
table? (i know I can write a query and do multiple sorts, but I want the
user to just click on the fields) Is there a simple function to do a primary
and secondary sort within the table in either design mode or datasheet view?
Thank you.
 
Very bad idea to have users viewing data directly in tables..... leads to
"oops, I didn't mean to delete that!" or "now how do I put the table back
the way it was?".

Tables are not designed for advanced sorting such as you wish ... simple
sorting is all ACCESS is designed to provide in tables.

Use a query to do advanced sorting.
 
You can sort by as many fields as you have in your query. Open the
QBE grid and you'll find a line in the lower portion named Sort. Sowr
Ascending or Descending on the fields you want.

HTH
 
Back
Top