Order records Access 2000

D

deb_misys

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!
 
R

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
 
J

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!
Click to expand...

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]
 
Top