How do I summ Checkbox True/False of Field in the Footer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have CheckBox Field for let's say 14, 20, 15, 13, 7, 32, etc..amounts of
Reservations. Let's say 20, 13 & 7 were Cancelled, the rest became a Visit.
I want to add all the Reservations that were Cancelled and those that turned
into a Visit.
Thank you..
 
LGPolanco,
In the query behind your report, add two calculated fields to your query
design grid.
Booked : IIF(YourChkField = True, 1, 0)
and
Cancelled : IIF(YourChkField = False, 1, 0)

Add these two fields to your report, and do a Count on each of them in the
footer...

Booked Cancelled
1 0
1 0
0 1
 
Back
Top