Yes/No records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joan - 18 Apr 2006 19:31 GMT

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?

Reply to this Message

freakazeud - 18 Apr 2006 23:04 GMT

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

Signature

Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
http://www.oli-s.de

> 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?

Reply to this Message