ALTER TABLE ORDER BY

  • Thread starter Thread starter Matt W
  • Start date Start date
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.
 
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.
 
Back
Top