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

ordering by date in a subreport 1
Report/Subreport Problems with Sorting/Grouping, Access 2003 2
Subreport with headings 4
Specify sort order in sub-reports 5
Using a Total from a Sub Report 3
Main Report Header is on SubReport 4
Subreport and Header Empty 1
SynNeed to account for null values in subreports 2

Top