changing order in a query

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

Guest

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.
 

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

Time input by work order 1
Order By in Query Spuriously Filled In 1
Order of parameter prompts Changed-why 9
order number in query 2
Sorting by Month field in simple query 4
Criteria in a query, last 5 digits 1
Can't create a report from my query in Access 1
Query of items ordered by month 18

Back
Top