Sum Boolean Data

[c8tz]

As with my post just a while ago, i have a second question relating to
this - I have records Pests such that if a Pest is found in a location
- "1" is given, otherwise "0". This is done in Excel.
With switching to Access, I would like to use Boolean (Yes/No) - But
to be able to add these.

I have kind of pictured my form to show that for a record , on the
form would have the list of pests - if a pest exists, then it is
checked.
These should then be added to give the number of reported pests etc.

Is this possible to do -

thanks,

 

[Allen Browne]

Tina already explained that heaps of yes/no fields is not the way to build a
database.

For guidance on how to build a relational structure, where one location can
have many pests, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html