Sum Boolean Data

  • Thread starter Thread starter c8tz
  • Start date Start date
C

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,
 
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
 
Back
Top