query/report

P

patti

I have a query that sorts correctly on ClientNo field.
Report based on that query has different sort; why would this be?
 
P

patti

I created a new report based on the query and that report was fine. So why
does the original report not work?

Access 2003.
 
D

Duane Hookom

It sounds like you are expected a report to honor the sorting of a query.
Don't. If you want records in a report sorted, use the report's sorting and
grouping dialog.
 
A

Allen Browne

In report design view, use the Sorting And Grouping pane to specify how you
want the report sorted.

This is much more reliable than hoping the report will sort as the query
does. In general, there's no point sorting the source query for a report.
 
P

patti

Thanks Duane and Allen.

Allen Browne said:
In report design view, use the Sorting And Grouping pane to specify how you
want the report sorted.

This is much more reliable than hoping the report will sort as the query
does. In general, there's no point sorting the source query for a report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.




.
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

Query sorts correctly, report does not 4
Control report grouping conditionally with a checkbox 3
Cross Tab Report Vs Dynamic coulmns 0
Incorrect sort on Month/year in report 4
Sort report by sum of counts 4
Access Access Report Works on One Machine but not Another 3
concatenated field in a report is not sorted 1
Parameter Query In Report Title 3

Top