Sorting and Grouping

D

Dale

I have a main report with a subreport that has a subreport. On the last
subreport I have put sorting on and also changed the query to have an order
by but it is not coming up in the sorted order on the main report. I run the
query and it is in the correct order. I run the subreport and it shows up
correctly. I run the subreport above that and it comes our correctly. What
could be missing that is making this come out in the wrong order?

Dake
 
K

KARL DEWEY

On the last subreport I have put sorting on ... it is not coming up in the
sorted order on the main report.
Did you set sort order for the main report?

Reports ignore any sorting done in a query.
 

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

Report/Subreport Problems with Sorting/Grouping, Access 2003 2
Subreport with headings 4
ordering by date in a subreport 1
Subreport Data Missing Inside Main Report 0
Using Subreports to create a Main Report 1
Using a Total from a Sub Report 3
Subreport not prt in sort order defined 0
Report Taking a Long Time to Print 0

Top