access+training+in+london - Tally Boolean - Query/Form

The UK's most regular instructor-led training courses.
Training information: access+training+in+london · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Tally Boolean - Query/Form

by - Jenny [guest] (2007 Feb 21 Wed, 17:48) Reply

In a form you can tally up the number of 'yes' in a boolean field. Can this be done in a query?

Also, if two participants from the same company attends an event. How do you tally up the company participation (either in a form or a query)? IE Total number of participants is 2 but total number of company participation is 1.

Appreciate your assistance.

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	2	book now	£495	£495
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	8	book now	£275	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Tally Boolean - Query/Form

by - trainer Garry gold contributer [188 posts] (2007 Mar 2 Fri, 09:43) Reply

The formulas would look like this (just change the ‘NameOfCheckBox’ to the name of your check box):

Yes (checked):

Sum(NameOfCheckBox)*-1

No (not checked):

Count(NameOfCheckBox)+Sum(NameOfCheckBox)

If you are doing this in a form or a report, you will need to add an = sign before the formulas.

· Microsoft Access Training Unleashes the Power of the Pivot Table
· Reasons to Consider Microsoft Access Training
· Take an Access Course to Learn About Relational Databases
· Learn about Subqueries in Access Courses
· Microsoft Access: Unleash the True Potential Today

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips