Another Northwind Query question ?

  • Thread starter Thread starter TonyB
  • Start date Start date
T

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
 
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
 
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
 
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!
 
Back
Top