Query and report differ

[Sue]

Hi all,

I have a query that I use for a report. The problem is
that when I run the query by itself and the report, the
records are sorted differently. This is an issue because
we use the report to do testing and then use the query to
enter the results in the table. Since the two do not
match, it makes it difficult to update the table. Please
note that I am sorting the primary key in ascending order
in the query. Also, it is not that the two are completely
different, just some of the records differ in order.

Any suggestions would be greatly appreciated. Thank you!

 

[chas]

Hi Sue,

try sorting in the Report as well via View>Sorting &
Grouping.

Access ignores the underlying sort order sometimes.

hth

chas