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/ -----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 <*> 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/
