Charlotte Foust
cfoust at infostatsystems.com
Fri Jan 16 12:52:54 CST 2004
It may be the way you have your control formatted. If the calculated control is formatted as a yes/no value, then you'll get the equivalent of 0 = No and anything but zero = yes. Change the format to a number and use something like Abs(Sum([CancelFlag])) Charlotte Foust -----Original Message----- From: John Clark [mailto:John.Clark at niagaracounty.com] Sent: Friday, January 16, 2004 10:40 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] I need a count of checkboxes in a report how come it doesn't it let me do something like this right in the report? If I sum it or total it, I get a "Yes" or a "No". >>> cfoust at infostatsystems.com 01/16/04 01:16PM >>> You don't even need to do that. Just use an Abs() function to return a positive value. Charlotte Foust -----Original Message----- From: Gary Kjos [mailto:garykjos at hotmail.com] Sent: Friday, January 16, 2004 10:00 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] I need a count of checkboxes in a report In your totals query do a sum on the Yes/No field times -1 to reverse the sign. ( -1 = Yes) CancelledLineCount: Sum([CancelFlag]*-1) Gary Kjos garykjos at hotmail.com >From: "John Clark" <John.Clark at niagaracounty.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: <accessd at databaseadvisors.com> >Subject: [AccessD] I need a count of checkboxes in a report >Date: Fri, 16 Jan 2004 12:12:25 -0500 > >I'm trying to whip up a report for a client who uses one of my >programs. They are tracking the meal sites for the elderly and I have >provided a list, by site, with their client's names, age, gender, race, >etc.. There are also six boolean fields that they track...for instance, >"Low Income"...and I need to count the ones that are checked for each >site. > >I know this is easy, and I could have swore I've done it before, but I >cannot figure out how at this particular moment. > >John W Clark >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Find high-speed 'net deals - comparison-shop your local providers here. https://broadband.msn.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com