Count Checkboxes Per Day

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

Guest

I need to display the days (and number of checked boxes) per day-- greater or
equal to the number specified (the paramater query stuff-- I know how to do
that little part!)

I've been thrown into this task with no Access experience-- any ideas?
 
Hi,


Check boxes in the same row?

SELECT *
FROM myTable
WHERE ABS(ck1+ck2+ck3+....+ckN ) >=10


as example, will keep the row where 10, or more, field ck_i are checked, in
the same row. That works on the principle that a check is -1 and a not check
is 0.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top