changing order in a query

G

Graham

In the original database all data are numbered in correct order. when I
design a query with the entire range it stays in this order but when i design
a query with some of the data (eg. not data from all days but just data from
day 2 under the column of "day"), some of the data suddenly changes order.
why would this happen???
 
J

Jerry Whittle

Data in tables really don't have an order. It might look like it, but don't
depend on it. If you want to see data in a certain order in a query, select
either Ascending or Descending for the fields in question. You may need to
change the order of the fields in the QBE grid as Access sorts on the
left-most field first that has a sort order selected then moves towards the
right.

To make matter more confusing, Forms will use the sort order of the query
used as the record source; however, Reports do not. If you want to see
records in a certain order in a report, you must use the report's sorting and
grouping options.
 
Top