Yes/No records

J

Joan

I have several fields that have yes/no and would like to run a report
that shows just the total of "yes" for each field. Some of the records
have yes in more than one field. Any suggestions?
 
F

freakazeud

Hi,
Since a Yes/No field's value can only be -1 or 0, all you need do is
add them with the Abs() function.

=Abs(Sum([YesNoField]))

Maybe you could provide us with your table structure though. It is unusual
to have a lot of yes/no fields in a table as it should rather be records in a
related table.
HTH
Good luck
 
Top