Default for query sorting

[abc]

How does a query sort by default?

we have no sort in our query, but when we add a record to our table it
sorts by primary key, but our query sorts by entry order?

 

[Douglas J. Steele]

I would treat it as random.

If the order's important, use an ORDER BY clause.

 

[abc]

thanks for responding quickly..

we found it was because our field "index"

 

[dbahooker]

if you want to use 'default sort' then you need to use an Access Data
Project

the concept is called 'Clustered Index'

even there; you should still use an ORDER BY


I really enjoy using this sort of order by

SELECT *

From Employees

Order by 4

that will sort by the 4th column


Hope that helps