Report duplicating each page 100 times

[Debora Barnes- Josiah]

Hi, I am a self- taught Access user (currently Access 2016). I don't know VBA. I have created a database of data for 5 counties; the Report creates 1 page per county. Due to file linking mishaps, I've been using Report View frequently to make sure I was generating pages for each county while setting up in Design View. Unfortunately I wasn't checking the page headers closely enough and at some point it started making 100 copies of each county page.


I can't find any problems in the group or page section headers, not to say there isn't one, just that I can't find it. Suggestions?

[June7]

Post your db so we can examine data structure and report design. Follow instructions at bottom of my post.

[Debora Barnes- Josiah]

Will do! Thanks.

[Debora Barnes- Josiah]

Attached is my database. It should prompt for County when you run the report, just hit enter. After posting my question, I tried copying it field by field into a new report. The problem shows up as soon as I add the group heading, "County" (aka "Geographic Area Name"), at the top of Detail. So I tried moving the County field up to County Header, but that didn't change the multiple pages issue and just dropped the name off of each page.

[Micron]

2 things I see wrong.
1 is that the sum of your report width + margins exceeds the page width - at least for me. I doubt that you're using some sort of European paper there in Nebraska!
2 - your report record source is based on a Cartesian query because there are no joins between your tables, so the number of records is basically a product of the records of the tables involved (I think 84 * 6 in your case). I will take another look, but not knowing the data I can only guess on how you'd fix it (other than to say you need to join or do something else).

For me, that would be 500 pages on my printer.
June7 - if you have anything to add, don't let me stop you. Sometimes I don't know when I'm butting in.

EDIT: it also appears that your data is poorly normalized, if at all. 111 fields in one table!! You might want to check out
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/
or find some tutorials you like.

[Debora Barnes- Josiah]

Well, I said I was self-taught... I started out with linked and joined tables, but the joins kept evaporating so I started moving everything into one table. That's why there are so many fields in the big table. Yeah, bad programming I know. The margins are a non-issue that probably arose when I made the copy to post.
So that's the 504 pages! I will read your normalization links, and then trying to reconstruct the joins. Thanks! (And since I clearly don't know what I'm doing, can you recommend a blog on basic joining?)

[isladogs]

Following on from previous comments ....

Join the tables using the geographic area field.
The report then has 6 pages. I don't have a page width issue.

The report has a group for the county field which isn't in the field list so the parameter box appears .
However it does nothing so remove the group by 'expression'

Other than that its a well laid out report

[Micron]

No advice re blogs, just have what I sent. You'd get lots of returns if you search. The trick is to find ones that are explained in a manner that works for you.
I seem to have made an error when adding the page margins to the report width in relation to the page width.

[Debora Barnes- Josiah]

Sorry for delay in responding, family stuff. Wow - that was simple - everything is working! Thanks so much to the three of you!!! ( ps - on my android phone; am not finding the place to note "resolved.")

[June7]

Thread Tools dropdown above first post.