Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access+training+in+london - tally boolean

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

ResolvedVersion Standard

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

RE: Tally Boolean - Query/Form

The formulas would look like this (just change the

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.