Order records Access 2000

[Guest]

What is the SQL statement to do the following:
Order first by X, then by Y, then by Z? All these are in ascending order.
All I can get it to do is to order by the first two. What am I doing wrong?
I have tried this both in the Design view and SQL. Thanks!

 

[Rick B]

In design view you would just make sure the fields were in the query from
left to right, then set the order field to "Ascending".

Rick B

 

[John Vinson]

What is the SQL statement to do the following:
Order first by X, then by Y, then by Z? All these are in ascending order.
All I can get it to do is to order by the first two. What am I doing wrong?
I have tried this both in the Design view and SQL. Thanks!

Eh? Could you post the SQL that's not working?

SELECT * FROM tablename
WHERE <criteria>
ORDER BY X, Y, Z;

should work fine for up to 255 characters total in x, y and z (see
Specifications in the offline help).

John W. Vinson[MVP]