Another Northwind Query question ?

[TonyB]

Hi,
I'm looking at the Orders Qry in the Northwind database and trying to
understand how the records returned are in alphabetical order. The Query
design view doesn't show any Sort values set for any of the fields in the
query, so I baffled why this query works this way ? Can anyone explain why
it works that way ?
TIA
Tony

 

[hermie]

Hi Tony

I think that table customers is saved in order of CustomersID
Open this table and sort on contact name and save the table Open the query
and you see that it is now sorted for contact name

Herman

 

[TonyB]

Hi Hermie,
I saved table Customers in a different sort order using contact name as you
suggested,
but it made no difference to the results of Orders Qry ? I can use the sort
order in the
query to achieve this result, I was just curious how it worked in this case
!
Cheers
Tony

 

[JohnFol]

With RDBMS you do not care how the data is stored, and there is no concept
of it being stored in order.
When access opens a table (or a query) it will default to use the PK if
there is one. Give it a try!