Minddumps
Registered User.
- Local time
- Today, 08:17
- Joined
- Jul 5, 2011
- Messages
- 73
This was driving me crazy until I figured out a simple solution. I figured if it drove me nuts there might be someone else who needs this info.
Background: I have a survey in which people rate items from 1 to 10. I've set-up my report to calculate how many 1's in field 1, field 2 etc. and how many 2's in field 1, field 2 etc. using the count(IIF... code
I was having trouble because the report didn't present itself as a Totals page (or like a Summary Page). It presented information for each individual record (which in this case is the same information for each record over and over again).
Attached is a sample of the print screen.
*SOLUTION*
In order to get Access to treat this Report as a Totals page, just move your information from the Detail section of the report to the Report Footer.
Background: I have a survey in which people rate items from 1 to 10. I've set-up my report to calculate how many 1's in field 1, field 2 etc. and how many 2's in field 1, field 2 etc. using the count(IIF... code
Code:
example
=Count(IIf([SermonPreparation]="1",0))
I was having trouble because the report didn't present itself as a Totals page (or like a Summary Page). It presented information for each individual record (which in this case is the same information for each record over and over again).
Attached is a sample of the print screen.
*SOLUTION*
In order to get Access to treat this Report as a Totals page, just move your information from the Detail section of the report to the Report Footer.