Why does the sort order change...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

This is not a particular problem, I'm just curious to know what determines
the secondary sort when I have a query sorted just on a single date field if
there are multiple records for the same date. Record order seems to change
from day to day and I can't figure out why.....thanks for any answers
Sheila
 
The order of records is essentially random unless you've got an appropriate
sort defined.

Tables are "buckets" of data: you should never make any assumptions about
the physical order of records in them, since that order can be changed by
doing updates to the table, and by compacting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting By Date 4
FILTER ANNULS SORT ORDER? 5
sorting a query 7
form sorting differently than query 2
Lose records when sort order is changed 4
Sorting Alphabetically and by date 3
Sort order in report 2
Advanced Sorting of Fields - Is it possible? 3

Back
Top