Calculation in a query

mashoutposse

New member
Local time
Yesterday, 23:24
Joined
Mar 12, 2011
Messages
2
Hi,

I am building a form in Microsoft Word with mail merge.

It will calculate how many boxes of glasses need to be loaded into a van.

I created a form that has many Yes/No Boxes for all different types of glasses.

I then calculate how many boxes are required in a query.

WhiskeyBoxes: [Number of Guests]/25 -

How do i ensure nothing is outputted in the mail merge if the box is No/"False" ?

As all calculations are outputted into the mail merge, and there is currently no regard for weather the box was ticked yes or no.

I hope that made sense and thanks in advancde, any help would be much appreciated.
 

Users who are viewing this thread

Back
Top Bottom