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.