Several Yes/No Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently using Access 2003. I have several yes/no fields of
staff-desired training requirements, whereby a yes/no is needed.

Example: A yes or no for training needs in Excel, PowerPoint...I have
already entered my staff informtion and checked the boxes of the training
they need. In addition, I have grouped training needs (Form) e.g.,
Computer-Data Related Skills Sets, Leadership...

How do I

1) Query all yes responses for e.g., Excel; eliminating 0 or Null
2) Total the number of Training Requirements - e.g., 30 folks want Excel
training
3) Avoid that destination error

I seriously need help with this.

Thanks
 
If you have several Yes/No fields in your table, one for each "training
requirement", you have ... a spreadsheet! You might need to set up your
data that way if you were using a spreadsheet, but Access is a relational
database.

If you keep your multiple yes/no fields, the next time there is a new
training requirement (or a change in the requirements), you will have to
modify:
* your table
* any queries that refer to those fields
* any forms that display those fields
* any reports that print out those fields
* any macros that refer to those fields
* any code/procedures that refer to those fields
THAT is a lot of maintenance!

Or you could normalize your data structure and take advantage of the
relationally-oriented features and functions that Access offers. For
example, if your data was organized relationally, a simple query could
"count up all the yes's". And if the requirements ever changed, you could
make a simple change in one table and be done with your maintenance.

Pay now or pay later...!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top