Report counting yes/no

[dsmith]

I'm using a yes/no field to indicate whether a work task is safe or unsafe.
I want to total the number of yes and the number of No answers to be used in
determining percentages on a report. I'm using =Abs(Sum([Q1])) to total my
yes answers (Q1 represents 1 of 5 questions) and =Count([Q1])+Sum([Q1]) to
total my No answers. Everything works fine except when the report prints, it
generates several pages instead of one sheet displaying the totals. I plan to
use a date range but if I show more than one entry for the same day, the
report will generate a page for each day. Although my totals are correct,
they are repeated based on the number of yes answers.
Can someone help point me in the right direction?
my table structure is shown below

cardID
Date
Q1
Q2
Q3...

 

[Lloyd]

I would create a select query with the 'total' button activated and with the
date range as criteria (select the where value in the total row for the date
field)

 

[dsmith via AccessMonster.com]

thanks Lloyd

I would create a select query with the 'total' button activated and with the
date range as criteria (select the where value in the total row for the date
field)

I'm using a yes/no field to indicate whether a work task is safe or unsafe.
I want to total the number of yes and the number of No answers to be used in

[quoted text clipped - 15 lines]

.