Ok, here goes another one for my monster report which has gotten even bigger. At this point I have a structure that looks like this:
Main Report, page 1
--subreport, page 2
--subreport, page 3
--subreport, page 4
--subreport, page 5
--subreport, continuous, page1 & 2
----subreport, page 3
----subreport, page 4
----subreport, page 5
My main problem right now is that on my continuous subform I am pulling totals from pages 3,4 & 5 below it, but it duplicates the first total on the secound iteration. In other words it pulls for the first detail the correct total of say $36.40, but for the second it pulls the same amount, instead of the $1.40 it should be. I cannot figure out why it is doing this, but it causes my reports to not add up to the correct amount. Any suggestions?
- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg
Main Report, page 1
--subreport, page 2
--subreport, page 3
--subreport, page 4
--subreport, page 5
--subreport, continuous, page1 & 2
----subreport, page 3
----subreport, page 4
----subreport, page 5
My main problem right now is that on my continuous subform I am pulling totals from pages 3,4 & 5 below it, but it duplicates the first total on the secound iteration. In other words it pulls for the first detail the correct total of say $36.40, but for the second it pulls the same amount, instead of the $1.40 it should be. I cannot figure out why it is doing this, but it causes my reports to not add up to the correct amount. Any suggestions?
- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg