G
Guest
I have a table with several Yes/No fields. I made a query that counts each
field and gives me the total number of 'Yes'. I made a report that shows me
the field name and the number of 'Yes'. In the report footer, I am trying to
total all the fields. I have made an unbound text box and used the following
as it's control source:
=Sum([CountOfDC]+[CountOfIB]+[CountOfDD]+[CountOfImage]+[CountOfODP]+[CountOfNetmail]+[CountOfLoanApp]+[CountOfVisa/MC]+[CountOfLoan1]+[CountOfLoan2]+[CountOfLoan3]+[CountOfSavAcctNum])
My problem is if one field doesn't have any 'Yes', then it won't total. I
don't know why. I've never had to do this before and I'm lost as to why it
won't add.
field and gives me the total number of 'Yes'. I made a report that shows me
the field name and the number of 'Yes'. In the report footer, I am trying to
total all the fields. I have made an unbound text box and used the following
as it's control source:
=Sum([CountOfDC]+[CountOfIB]+[CountOfDD]+[CountOfImage]+[CountOfODP]+[CountOfNetmail]+[CountOfLoanApp]+[CountOfVisa/MC]+[CountOfLoan1]+[CountOfLoan2]+[CountOfLoan3]+[CountOfSavAcctNum])
My problem is if one field doesn't have any 'Yes', then it won't total. I
don't know why. I've never had to do this before and I'm lost as to why it
won't add.