Translating Query formatting

D

Dragon

I have a query that is set up to display records ordered by plan date then by
start date.
When I use the query in a report, it doesn't appear to sort the records.
Is there a way to make the report format the results the same as the query?

Thanks,
Dragon
 
D

Duane Hookom

Reports should always be sorted using the Sorting and Grouping dialog in
Report Design. The order in the query often has no effect on the order in the
report.
 
D

Dragon

Found it! Thanks!

Dragon

Duane Hookom said:
Reports should always be sorted using the Sorting and Grouping dialog in
Report Design. The order in the query often has no effect on the order in the
report.
Click to expand...
 

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

Access Dcount (multiple criteria) 3
Multiple records, multiple queries, one page report. 1
Including query dates in report 1
Summary Report 3
Records Appear In the Query, But Not On the Report. 5
Parameter Query In Report Title 3
Printing Query Promt Parameters in a report 2
how do I resolve a conflict with Unmatched records 1

Top