Records not sorted in Report but sorted in underlying query

  • Thread starter Thread starter Tina Hudson
  • Start date Start date
T

Tina Hudson

I have 3 subreports in a report. The main report has no
underlying recordsource. The 3 reports each have their
own query, which is sorted on "schoolname". When I run
the query, the schools are listed correctly. When I run
the report, the schools are not listed correctly.

Please tell me what I have done wrong. Thanks,
Tina Hudson
 
Sorting in reports can only reliably be done by using the Sorting and
Grouping dialog in the Report Design.
 
Duane said:
Sorting in reports can only reliably be done by using the Sorting and
Grouping dialog in the Report Design.
Click to expand...

Thanks, that would also answer my question three posts down. Do you,
perchance, know how to set the "Sorting And Grouping" stuff in VBA?

Thx,
Anno.
 
Tina said:
I have 3 subreports in a report. The main report has no
underlying recordsource. The 3 reports each have their
own query, which is sorted on "schoolname". When I run
the query, the schools are listed correctly. When I run
the report, the schools are not listed correctly.
Click to expand...


How did you specify the sorting for the subreports? It
should be done in the each subreport's Sorting and Grouping
window (View menu).
 
Thanks.

Tina
-----Original Message-----
Sorting in reports can only reliably be done by using the Sorting and
Grouping dialog in the Report Design.

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
That did it. I had actually specified the sorting in the
subreports, but don't know why, or even when, I did. The
sorting was not on the field I wanted it sorted on. Works
great now.

Can't tell you how much I appreciated your response!
Thank you.
Tina Hudson
 
Back
Top