total check box

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

have a list of invitees to an event, the first column is a check box -
"Registered"

at the end of report I'd like to show below the number of invitees I'd like
to show the total of attendees that are check (i.e. yes or true).

appreciate any help
 
Sal said:
have a list of invitees to an event, the first column is a check box -
"Registered"

at the end of report I'd like to show below the number of invitees I'd like
to show the total of attendees that are check (i.e. yes or true).
Click to expand...


Total detail records (attendees)
=Count(*)

Number pf detail records with registered checked
=Sum(IIf(Registered, 1, 0))
or
=Abs(Sum(Registered))
or
=-Sum(Registered)
 
Marshall / Sal

=-Sum(Registered)

worked fine! thanks. However I've tried to make sums for other check boxes
(luncheon, reception and breakfast, which are in the query that the report is
based on but not in the report and I keep getting the same number as
Attendees?

any guidance is appreciated.
 
That could be a lot of things so I can't tell without seeing
a Copy/Paste of your query's SQL view.
 
Back
Top