table of contents with multiple entries

[prairiewind via AccessMonster.com]

I have a table of contents that I've made using code found on this site.
However, several times in my report, a person's name is repeated and I'd like
to include both pages in the table of contents.

John Doe.................1, 23

Any suggestions would be appreciated.

 

[Allen Browne]

Presumably you have set up a table where you record the customer's name, and
the page number. And you use the Print event of the (Detail?) section of
your report to populate this table. And then you show the TOC as a subreport
on your report.

If you have all that working, the remaining issue is how to create a
concatenated list of page numbers beside each customer. This will involve
some more code along these lines:
http://www.mvps.org/access/modules/mdl0004.htm

(The assumption here is that you used the CustomerID with the page number in
the temp table you used for the table of contents.)

 

[prairiewind via AccessMonster.com]

Thanks Allen, That is exactly what I've done up to this point and is exactly
what I am needing. So many times, the answer is out there somewhere, but you
always seem to know where to go for it. Apprectiate the help.

Jeff

Presumably you have set up a table where you record the customer's name, and
the page number. And you use the Print event of the (Detail?) section of
your report to populate this table. And then you show the TOC as a subreport
on your report.

If you have all that working, the remaining issue is how to create a
concatenated list of page numbers beside each customer. This will involve
some more code along these lines:
http://www.mvps.org/access/modules/mdl0004.htm

(The assumption here is that you used the CustomerID with the page number in
the temp table you used for the table of contents.)

I have a table of contents that I've made using code found on this site.
However, several times in my report, a person's name is repeated and I'd

[quoted text clipped - 4 lines]

Any suggestions would be appreciated.