Sorry. I wasn't clear. I have an SQL database with table with field named 'ID', primary key, clustered. When the table is loaded, the records are loaded in physical order: ID = 1,2,3, etc. Hence, when I do the query mentioned above within the SQL database, I get records with ID = 1,2,3. etc in that order. However, when that table is linked to Access and I run the same query in Access, I get records with ID = 1,5,23,etc. Why doesn't Access display results same as SQL?