Access problem creating ACCESS query filtered by both check boxes and option groups.


Joined
May 14, 2012
Messages
2
Reaction score
0
I am trying to filter a query based on 3 check box selections and 2 seperate option groups

I am using

SELECT tblNames.LAST, tblNames.FIRST, tblNames.PORT, tblNames.OFFICER, tblNames.SUPV, tblNames.PERMIT, tblNames.DFO_ECC, tblNames.PASSPORT, tblNames.PASSPORT_EXP
FROM tblNames
WHERE (((IIf(forms![Report Menu]!PERMIT,[PERMIT]=True,True))=True) And ((IIf(forms![Report_Menu]!DFO_ECC,[DFO_ECC]=True,True))=True) And ((IIf(forms![Report Menu]!PASSPORT,[PASSPORT]=True,True))=True));

for the 3 check boxes and it works perfectly.

I am trying to add 2 different Option groups that have

Group 1
Officers
Supervisors
All

Group 2
Port A
Port B
ALL

I want to select one button to pull up the report and filter by each of the option group selections and include all records that have yes or no values matching any of the 3 checkmarks.

I am unsure how to incorporate the Option groups into the SQL of the query

please help
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top