Sort Microsoft Access Records Using Multiple Criteria

  • Thread starter Thread starter dovz
  • Start date Start date
How do I Sort Microsoft Access 2002 records using multiple criteria?

Criteria has to do with filtering data, not sorting it.
Why don't you take a moment and be more specific about what you are
trying to do. An example is always helpful.
And it may make a difference, if you are wanting to do whatever it is
you want to do, on a report or form.
 
Use the query builder and the sort order is determined by the order the
fields appear in the grid.
 
Criteria has to do with filtering data, not sorting it.
Why don't you take a moment and be more specific about what you are
trying to do. An example is always helpful.
And it may make a difference, if you are wanting to do whatever it is
you want to do, on a report or form.

Thank you. What I am wanting to do is to organize a list of people
and addresses by country, state, then city, etc. What I currently
have is the list, but not in that order.
 
Thank you. What I am wanting to do is to organize a list of people
and addresses by country, state, then city, etc. What I currently
have is the list, but not in that order.

Let me clarify further. I have a table with a list of names,
addresses, etc. I want to sort them by country, state, then city,
etc. however, i want to columns in the same order as they are now,
name, organization, then addresses, etc.
 
Let me clarify further. I have a table with a list of names,
addresses, etc. I want to sort them by country, state, then city,
etc. however, i want to columns in the same order as they are now,
name, organization, then addresses, etc.

Did you not read or understand this line?
And it may make a difference, if you are wanting to do whatever it is
you want to do, on a report or form.
 
Back
Top