Query will not sort the table

[CalvinFarmer]

I have a query which is supposed to sort a table. For some reason, it doesn't completely sort it correctly. The table is kind of big (300,000 rows), but it should still work. Sometimes the field won't be in ascending order, and sometimes it will split up a group of records from the field into different places in the table. Everything will work fine when it is a "select" query. But when changed to a "make table", it doesn't sort correctly. Any ideas?

 

[KenReay]

Hi

AFAIK tables are are not in any particular Order, if you with to retrieve data from a table in some sequence, then you must do it via a SELECT query, with an ORDER BY clause

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK