Error Counting Check Boxes

N

Nick CWT

In database #1 report I use the following expression to count checked check
boxes and it works.

=Sum([Attachment Pre-test Completed Child1]+[Attachment Pre-test Completed
Child2]+[Attachment Pre-test Completed Child3]+[Attachment Pre-test Completed
Child4]+[Attachment Pre-test Completed Child5]+[Attachment Pre-test Completed
Child6]+[Attachment Pre-test Completed Child7]+[Attachment Pre-test Completed
Child8])*-1

When I exported this report to database #2 I get #Error in Print / Print
Preview? As always I'm stumped. Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Check Boxes 4
Ignore empty fields in Criteria append 7
convert multicolumn/multirow table into two structured/formatted columns => feasible? 5
Changed query, Form went Blank 2
Setup Assistant Errors and Connection Errors 1
Totalling check boxes 5
Outputting to PDF in A2007 0
Counting results of "yes" check boxes and combo box selections 2

Top