ALTER TABLE ORDER BY

M

Matt W

Can anyone possibly tell me why this would not work:

ALTER TABLE PARENTS ORDER BY PARENT;

With of course PARENTS being table and PARENT being field.

Am I seeing something wrong.
 
J

John Vinson

Can anyone possibly tell me why this would not work:

ALTER TABLE PARENTS ORDER BY PARENT;

With of course PARENTS being table and PARENT being field.

Am I seeing something wrong.
Click to expand...

Yes. You're assuming that tables have order. They don't.

Use a Query rather than a table datasheet if you want to see records
in a particular order.
 
Top