Thank you John, worked perfectly.
While I am here, may I say thank you on behalf of all the readers for your book "Building Microsoft Access Applications", which I purchased a short while ago and still working my way though. Thoroughly recommended to members of all Access forums. Regards Norman Pearce IM&T Learning Manager The Training Centre Ealing Hospital NHS Trust T: 020 8967 5085 F: 020 8967 5646 E: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Developing the foundations for your success -----Original Message----- From: John Viescas [mailto:[EMAIL PROTECTED] Sent: 17 January 2006 22:26 To: [email protected] Subject: RE: [ms_access] Counting Checkboxes in report Footer Norman- Use: =Sum(Abs([NoShow])) John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ <http://www.viescas.com/> -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Pearce, Norman Sent: Tuesday, January 17, 2006 12:35 PM To: '[email protected]' Subject: [ms_access] Counting Checkboxes in report Footer I am working on a report regarding course activity & including identification of delegates that were a NoShow. The NoShow field is a logical field displayed in the Detail band of the report. In the group footer, I want to count the number of NoShows. Using: =count([NoShow]), merely counts all the noshow fields, 1 for each record irrespective of true or false. I have tried various other options, but currently have failed miserably. I would appreciate some guidance here. Regards Norman Pearce IM&T Learning Manager The Training Centre Ealing Hospital NHS Trust Developing the foundations for your success [Non-text portions of this message have been removed] Yahoo! Groups Links _____ YAHOO! GROUPS LINKS * Visit your group "ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
