Another Table of Contents Question

[Janet]

I posted a question yesterday and made progress with the reports I'm trying
to generate. What I'm trying to do is to take a Table of Contents Master
file and generate a separate report for each category - i.e., all of the
files starting with the letter "A" would print on one report, all the B's
would print on another report, etc.
I used the Sorting & Grouping command - Group Header Yes and Group On with
"Prefix Characters"- Group Interval is set to 1 (to pick up the first letter
of each category. What that did was to separate report by a's, b's and c's,
but it all printed out on one report. I need to generate one report for each
letter.

I hope I'm making sense. I'm new to Access (can't you tell??!).

Thanks for your help.

Janet

 

[Jeff L]

Could you not simply put a page break in your group footer? That way
you don't need to make 26 reports, you can just use 1 and each letter
will start at the top of a new page. Forgive me if I'm not
understanding completely.

Hope that helps!

 

[Janet]

When I enter the page break, it only prints one record per page - it won't
print the a's on one page, then the b's, etc. I don't mind have separate
reports for each letter. I've tried the page break in a couple of places in
the design view.

Any other ideas?

 

[Jeff L]

Hmm...I'm not sure you put it in the correct place. In your Sorting
and Grouping where you set your group header to yes, there should be
another setting for Group Footer. Change that to yes. Now put the
page break in that area. I have tested this and it works great!

 

[Janet]

THANKYOUTHANKYOUTHANKYOU!

Hmm...I'm not sure you put it in the correct place. In your Sorting
and Grouping where you set your group header to yes, there should be
another setting for Group Footer. Change that to yes. Now put the
page break in that area. I have tested this and it works great!