Auto Sort

[Jennifer]

When I upload an excel file into Access I have the customers ordered in a
specific way (not alphabetically or anything like that). However when I make
queries it automatically puts them into alphabetical order. Is there any way
to have the queries' display have the same order like in the tables?

...I hope that makes sense.

 

[Douglas J. Steele]

You can't assume anything about the order of data in tables. Data is put
wherever Access thinks it fits best, and compacting the database may
rearrange the data. The only way to be sure of the order is to use a query
with an appropriate ORDER BY clause.