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???

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Graham" wrote:

> 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???