Conditionally make headers/footers visible

  • Thread starter prairiewind via AccessMonster.com
  • Start date
P

prairiewind via AccessMonster.com

I have a query that has the following fields; AtlasSection, AtlasPage,
PersonName, AddressInfo. The result of the report should look like:

AtlasSection AtlasPage PersonName AddressInfo
1 1 JohnDoe Anywhere
1 2 JohnDoeJr Anywhere

2 2 JohnDoeIII Anywhere

2 4 JohnDoeIV Anywhere

2 5 JohnDoeV Anywhere
2 6 JohnDoeV1 Anywhere

and so on.

I have no problem getting it grouped by AtlasSection and AltasPage. I've
been trying for a week now to figure out how to conditionally make the
headers and footers visible so that the report prints exactly like
illustrated above. For each AtlasSection, the odd and even pages that show
when the atlas is open (1-2, 5-6, but not 4-5 and so on), need to be grouped
together and then a blank area.

Am open to any help, suggestions, ideas, critics, etc. and the little hair I
have left is quickly being pulled out!!!

Jeff
 
P

prairiewind via AccessMonster.com

One follow up is maybe this should be under the report discussion group.
However, the thought in the back of my mind was in a query, to compare the
AtlasPage of the current record with the previous/next record (either way I
can work with). If the AtlasPage difference between the two is more than one,
then return the result as True. Then in the report, I can use the True/False
result to force the header/footer to be visible or not.

Jeff
 
J

John Spencer

(AtlasPage -1) \ 2 will generate
Page Result
1 0
2 0
3 1
4 1
5 2
6 2
etc.

So if you include expression in the query, you can group by it and keep
pages 1&2 together, 3&4 , 5&6 , etc. Use the expression for grouping.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
P

prairiewind via AccessMonster.com

I know that a person isn't suppose to write in all caps, but THANK YOU.
Exactly what I was needing. It's amazing how a person can get on one track
and keep trying to make it work when there is another simple solution out
there.

Jeff
 
Top