How to create Table of Contents for Access Report? 1

[Sherman6789]

Hello!

I have a 70 page report that shows information from various states. The number of pages for each state varies according to the information contain in it. I need to create a table of contents to be attached or printed which show the page number that each states info begins. I know how to do this in Word and WordPerfect, but would like it done directly in Access, if possible.

Also need to have each state start on a new page. I have done this before with "force new page" in the preferences. However, this time it make a new page for every item no matter what state is shown. They are sorted by state and city in alpha order within the state. Only the state field is used to advance the pages. BUT it doesn't work.

Any assistance will be appreciated.

WRS

 

[CosmoKramer]

Here is a link to a MS KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;131588&Product=acc97

Hoc nomen meum verum non est.