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.
 
You must log in or register to reply here.

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

Access Sorting and grouping using multiple tables 0
Printing of sub-report skips to second page. 3
Another Table of Contents Question 4
Saving page number from report 5
Sort report by sum of counts 4
Hyperlink to Page number in Report that is exported to PDF 5
Create Table of Contents 2
Print Report If Sub-Report Has Data 2

Back
Top