total check box

[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

 

[Marshall Barton]

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).

Total detail records (attendees)
=Count(*)

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

 

[Sal]

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.

 

[Marshall Barton]

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