98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+in+london - Tally Boolean - Query/Form
access+training+in+london - Tally Boolean - Query/Form
Resolved · Low Priority · Version Standard
Wed 21 Feb 2007, 17:48Jenny (guest) said...
Tally Boolean - Query/Form
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
Fri 2 Mar 2007, 09:43Trainer Garry said...
RE: Tally Boolean - Query/Form
The formulas would look like this (just change the
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
