Query based on Check boxes

  • Thread starter Thread starter MackBlale
  • Start date Start date
M

MackBlale

I have a Table, tblemployees that stores various info, name, DOB, salary
amount, etc. I also have three check boxes on the form: unpaid employee,
inactive employee, and terminated employee. I need to be able to run a
query that will count the number of employees based upon which boxes are
checked. For example if my boss wants to know how many employees we have
excluding those which are inactive and unpaid. Thanks in advance for the
help
 
Check boxes store data as -1 (minus one) or 0 (zero).
Just use those values as criteria. Or Abs(Sum([CheckBoxField])) to count
checkboxes.
 
Back
Top