Records not sorted in Report but sorted in underlying query

[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

 

[Duane Hookom]

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

 

[Anno v. Heimburg]

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

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.

 

[Marshall Barton]

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.

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

 

[Tina Hudson]

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





.

 

[Duane Hookom]

Allen Browne has code at his site
http://members.iinet.net.au/~allenbrowne/tips.html for setting the sorting
at run-time.

 

[Tina Hudson]

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