REPORT / QUERY - sort order question

[kealaz]

Hello,

I have a report with a query for it's record source. All the information
is accurate, however, I specify in the query for the information to be
displayed ASCENDING based on the USED_ON field.

If I run the query and view the information, it is correct, however, when I
run the report, it is backwards (descending).

Could I have some setting somewhere in the design of my report making this
change? I thought reports were just reflective of the information from the
query?

Thank you for any assistance you can provide!!!

 

[Ken Snell [MVP]]

Reports ignore the ORDER BY clause in the record source query. Use the
Sorting & Grouping feature to set the sort order for your report.

 

[fredg]

Hello,

I have a report with a query for it's record source. All the information
is accurate, however, I specify in the query for the information to be
displayed ASCENDING based on the USED_ON field.

If I run the query and view the information, it is correct, however, when I
run the report, it is backwards (descending).

Could I have some setting somewhere in the design of my report making this
change? I thought reports were just reflective of the information from the
query?

Thank you for any assistance you can provide!!!

The Sort order of the query is irrelevant in the report.
To sort the records in the report use the Report's Sorting and
Grouping dialog.
In Report Design view, click:
View + Sorting and Grouping

 

[kealaz]

THANK YOU SO MUCH!!! YOU GUYS ARE THE BEST!!!