Access MS ACCESS -- Help with query code filtered by option groups and check boxes

G

govuser1

Joined
May 14, 2012
Messages
2
Reaction score
0
I would like to create a query that uses 3 check boxes and 2 Option groups to filter the data.

I am not sure what code to use. I have got the 3 check boxes working but i can not figure out how to add the option groups to the same query.

3 Check boxes
Data1 (yes/no field)
Data2 (yes/no field)
Data3 (yes/no field)

Option group 1
Employee type 1 (yes/no field)
Employee type 2 (yes/no field)
ALL

Option group 2
Location 1 (data stored as text (location name))
Location 2 (data stored as text (location name))
ALL

Any help would be appreciated i have been googling this and can not figure out how to merge the example i have found.
 
Back
Top