Printing Table of Contents

  • Thread starter Thread starter \L.M. via AccessMonster.com\
  • Start date Start date
L

\L.M. via AccessMonster.com\

I have used the technique posted on the MS website to create a Table of
Contents for a report. When I try to print it via a report, if I add a
grouping header, it won't print in alphabetical order. I have even tried
making the data source of the report to be a query that sorts the table of
contents table. Has anyone has this issue?
 
I have used the technique posted on the MS website to create a Table of
Contents for a report. When I try to print it via a report, if I add a
grouping header, it won't print in alphabetical order. I have even tried
making the data source of the report to be a query that sorts the table of
contents table. Has anyone has this issue?
Click to expand...

Any sort order you have in your query is irrelevant to the sort order
of a report.
When you added that group header you also told Access to sort
according to the field used as group header.

What field do you wish to sort the report on?
Open the Report's Sorting and Grouping Dialog,
View + Sorting and Grouping
and add the field you want to sort on to the Field/Expression list.
Then move this field to the top line by selecting the line and
dragging it up.
 
Back
Top