If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
total check box
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 |
#2
|
|||
|
|||
total check box
Sal wrote:
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) -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
total check box
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" wrote: Sal wrote: 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) -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
total check box
That could be a lot of things so I can't tell without seeing
a Copy/Paste of your query's SQL view. -- Marsh MVP [MS Access] Sal wrote: =-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? "Marshall Barton" wrote: 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 wrote: 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). |
Thread Tools | |
Display Modes | |
|
|