Order records Access 2000

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

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