How do I Create an Index of a Report in Access

[Ross Hamilton]

I have a Report that creates a Catalogue of Products we sell under various
Headings eg:

Books, Recordings, Health Food, Diet Foods, etc

There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page numbers
change depending on New or Deleted product ranges.

Can anyone help me to create an Index using Access so that the page numbers
go against the Headings.

Thanks in advance.

Ross

[fredg]

On Wed, 17 Nov 2004 12:00:29 +0800, Ross Hamilton wrote:

I have a Report that creates a Catalogue of Products we sell under various
Headings eg:

Books, Recordings, Health Food, Diet Foods, etc

There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page numbers
change depending on New or Deleted product ranges.

Can anyone help me to create an Index using Access so that the page numbers
go against the Headings.

Thanks in advance.

Ross

What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'

For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'

You must actually run the report (in preview, or by actually printing
it).
Then run a separate report, using the TOC table made by the first
report, to print out just the Table of Contents.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Allen Browne]

See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...

I have a Report that creates a Catalogue of Products we sell under various
Headings eg:

Books, Recordings, Health Food, Diet Foods, etc

There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page
numbers
change depending on New or Deleted product ranges.

Can anyone help me to create an Index using Access so that the page
numbers
go against the Headings.

[Ross Hamilton]

Sorry, I am using Access97, and the link is for 2000 do you know of a way in
97??

Ross
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...

I have a Report that creates a Catalogue of Products we sell under various Headings eg:

Books, Recordings, Health Food, Diet Foods, etc

There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually create an Index which takes HOURS, the problem is the Catalogue page
numbers
change depending on New or Deleted product ranges.

Can anyone help me to create an Index using Access so that the page
numbers
go against the Headings.

[Allen Browne]

Ross, I think you will find that the same approach works in A97, but there
is an earlier version of the same article.

To find it:
Go to support.microsoft.com
Choose the knoweldgebase.
Ask for the advanced search.
Specify the product as Access.
Run a search for Table of Contents" as the "exact phrase".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41******@news.highway1.com.au...

Sorry, I am using Access97, and the link is for 2000 do you know of a way
in
97??

Ross
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269
"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...

>I have a Report that creates a Catalogue of Products we sell under various > Headings eg:
>
> Books, Recordings, Health Food, Diet Foods, etc
>
> There are 82 Headings and a total of 6000+ products which makes a big
> Catalogue.
> A Printed version of the Catalogue is done every 2 Months and we manually > create an Index which takes HOURS, the problem is the Catalogue page
> numbers
> change depending on New or Deleted product ranges.
>
> Can anyone help me to create an Index using Access so that the page
> numbers
> go against the Headings.

[Ross Hamilton]

Found it thanks very much.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

Ross, I think you will find that the same approach works in A97, but there
is an earlier version of the same article.

To find it:
Go to support.microsoft.com
Choose the knoweldgebase.
Ask for the advanced search.
Specify the product as Access.
Run a search for Table of Contents" as the "exact phrase".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41******@news.highway1.com.au...

Sorry, I am using Access97, and the link is for 2000 do you know of a way in
97??

Ross
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269
"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...
>I have a Report that creates a Catalogue of Products we sell under

various

> Headings eg:
>
> Books, Recordings, Health Food, Diet Foods, etc
>
> There are 82 Headings and a total of 6000+ products which makes a big
> Catalogue.
> A Printed version of the Catalogue is done every 2 Months and we

manually

> create an Index which takes HOURS, the problem is the Catalogue page
> numbers
> change depending on New or Deleted product ranges.
>
> Can anyone help me to create an Index using Access so that the page
> numbers
> go against the Headings.

[Ross Hamilton]

Fred, Thanks for your prompt response I found the Access97 article and now
all I have to do is make it work.

"fredg" <fg******@example.invalid> wrote in message
news:1n*****************************@40tude.net...

On Wed, 17 Nov 2004 12:00:29 +0800, Ross Hamilton wrote:

I have a Report that creates a Catalogue of Products we sell under various Headings eg:

Books, Recordings, Health Food, Diet Foods, etc

There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually create an Index which takes HOURS, the problem is the Catalogue page numbers change depending on New or Deleted product ranges.

Can anyone help me to create an Index using Access so that the page numbers go against the Headings.

Thanks in advance.

Ross

What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'

For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'

You must actually run the report (in preview, or by actually printing
it).
Then run a separate report, using the TOC table made by the first
report, to print out just the Table of Contents.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Thug Passion]

> Can anyone help me to create an Index using Access so that the page numbers

go against the Headings.

Depends. Is your report grouped by anything? For example, if it's a
product list, is it grouped by product family, so toothbrush and
toothpaste come together, and then popcorn comes somewhere else? If
not you can use the product itself, but that's going to be an awefully
long iindex.

Go into your report's design, then right-click on either detail or the
group heading, and say "add event" or something like that, should be
the option on the top. Another menu comes up, and you want the code
designer to write a VB function.

Declare a report-level string variable that's going to hold your
index. Like:

dim sIndex as string

Then in the sub you just added, when your data changes, you want
something like:

If InStr(sIndex, [CurrentDataValue]) = 0 Then
sIndex = sIndex + [CurrentDataValue]
sIndex = sIndex + String(" ", 30) + [Page] + vbCrLf
End If

( You can put that on one line. )

Now go back into your report's design, add a text-box to the report
footer, set it's CanGrow property to true, and then add more code to
when the report-footer gets formatted, and say:

Textbox391.Text = sIndex

Change 391 to refer to the one you just added to the report footer
section.