Order Problem, what's wrong?

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi, Why sometimes the "Order by field1, field2" does not work?
What I found was the field1's order was right, but for repeated values of
field1, the field2 did not order.

This happen to a joint tables query. If I change the sequence of adding
fields to the query, the "Order by field1, field2" worked fine.
 
Queries in Access have an Order By Property, which can override the ORDER BY
clause in the SQL String. View the property window for the query, and make
sure this is not happening.

The Order By Property get's set whenever you perform a sort in the datasheet
view of the query.
 
Back
Top