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

Access Discussion in 'Microsoft Office' started by govuser1, May 14, 2012.

  1. govuser1

    govuser1

    Joined:
    May 14, 2012
    Likes Received:
    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
     
    govuser1, May 14, 2012
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ai_enjoi

    Access help wth combo boxes, ms access

    ai_enjoi, Apr 22, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    364
    ai_enjoi
    Apr 22, 2007
  2. norajr

    Word MS Service Pack 2 crashes BOTH Word and Outlook

    norajr, Jul 6, 2009, in forum: Microsoft Office
    Replies:
    4
    Views:
    1,021
    norajr
    Jul 6, 2009
  3. skiptotheend

    Access Access 2007 - Using Cascading Combo Boxes to Filter a Query

    skiptotheend, Oct 12, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,132
    skiptotheend
    Oct 12, 2009
  4. missWhite

    Access Access 2003 Check boxes

    missWhite, Jun 17, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    766
    missWhite
    Jun 17, 2010
  5. BeHokie

    Excel Tabbing between boxes in Excel 2007 forms

    BeHokie, Apr 3, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    758
    BeHokie
    Apr 3, 2011
  6. A_Barnes
    Replies:
    1
    Views:
    971
    apr pillai
    Jul 23, 2011
  7. sprashanthk

    Access HELP NEEDED: MS ACCESS OPTION GROUP

    sprashanthk, Aug 24, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    692
    sprashanthk
    Aug 24, 2011
  8. snoopy12

    Access Access 2007 DB reaching 2GB limit and Transform query

    snoopy12, Mar 20, 2012, in forum: Microsoft Office
    Replies:
    0
    Views:
    760
    snoopy12
    Mar 20, 2012
Loading...