Test if a group of fields are -1

[andy49]

I have about 14 chkboxes (varies from year to year) and need to check whether all of them are checked


I figured I could do it by checking each one in a loop but wondered if anyone has a faster way.

The values are stored in a table

fields are ID (autonumber)


chk1 Boolean
chk2 Boolean etc


Thanks in anticipation

Andy

[CJ_London]

In a query

SELECT *
FROM myTable
WHERE chk1=false or chk2=false.......

Or by storing them in normalised way (i.e. record for each checkbox) so the query doesn't need to be changed each year

[andy49]

Can you clarify a little what you mean about "storing them in a normalised way".

I need a checkbox for each for each class (there are 18 classes this year but could be 21 other years)

I'm already creating the checkbox form in vba.

A real nuisance!!


Sent from my iPhone using Tapatalk

[CJ_London]

Can you clarify a little what you mean about "storing them in a normalised way".

I indicated in my post

(i.e. record for each checkbox)

there are a number of ways but all depends on what your db does.

I've no idea what chk1, chk2 etc does, but perhaps it is stages to be completed. So maybe you have a table of stages and have a many to many table between stages and the records in your 'main table'. If a record exists in the many to many table, then that is the equivalent of chkbox=true. No record and that is the equivalent of chkbox=false. Or the other way round. As I said it depends on how your db works.