Sort Microsoft Access Records Using Multiple Criteria

[dovz]

How do I Sort Microsoft Access 2002 records using multiple criteria?

 

[fredg]

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.

 

[ruralguy via AccessMonster.com]

Use the query builder and the sort order is determined by the order the
fields appear in the grid.

 

[dovz]

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.

 

[dovz]

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.

 

[fredg]

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.