There may (must be) be a better & neater solution, but as a quick and dirty solution
run an initial query which derives a value frrm the checkbox columns, much as I hate to say it using the IIF construct
select mycol1,mycol2,mycol3,iif(myCheckbox1=true,1,0) as ckb1,iif(myCheckbox2=true,1,0) as ckb2....iif(myCheckbox10==true,1,0) as ckb10
then run another query referrring to the first one
summing the values of ckb1..ckb10
then a third query refering to the intermediate one above extracting if the sum is either 1 or 10
Its nasty but it should work. I have been forced to use such a strategy before and am not proud of it.
I have 30 check boxes (not my design) on one form and I need to know how to do a query when only one is selected or 10 is selected ...If you need more info, please reply.. Thanks so much
HI MRay and "Welcome to the Forum"
Are you viewing the Results in a Report? I have such a form as well and is based on an underlying query. Thing is, whenever I populate a CheckBox, it shows in the Report automatically. The trick here is that Before that is done I have ONE CheckBox called quite simply Print. When that is checked, it opens the Report to show only those records that have the Print CheckBox selected, and all the other fields come along for the ride.....that means the other CheckBoxes and all.
A bit more about your design or can you make a copy and Zip and Post it here to take a look at? Might be able to fix that for you.