How to: create a Totals Report so info doesn't keep repeating per the # of records.

[Minddumps]

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

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.

 

[umair434]

thanks maria! it was driving me insane as well. You saved me alot of trouble

 

[Minddumps]

You're welcome!

 

[umair434]

hey! do you happen to know how to use todays date to show a report? I want the user to see data for today only (I don't want them to enter the date themselves).

thanks!

 

[Minddumps]

hey! do you happen to know how to use todays date to show a report? I want the user to see data for today only (I don't want them to enter the date themselves).

thanks!

Try putting <= CURRENT_DATE as a criteria in the date column of your query for the report.

 

[umair434]

I used "date()" and it worked. Thanks!!!