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

Discussion in 'General Software' started by govuser1, May 14, 2012.

  1. govuser1

    govuser1

    Joined:
    May 14, 2012
    Messages:
    2
    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. skiptotheend
    Replies:
    0
    Views:
    938
    skiptotheend
    Oct 12, 2009
  2. missWhite

    Access 2003 Check boxes

    missWhite, Jun 17, 2010, in forum: General Software
    Replies:
    0
    Views:
    613
    missWhite
    Jun 17, 2010
  3. A_Barnes
    Replies:
    1
    Views:
    739
    apr pillai
    Jul 23, 2011
  4. sprashanthk

    HELP NEEDED: MS ACCESS OPTION GROUP

    sprashanthk, Aug 24, 2011, in forum: General Software
    Replies:
    0
    Views:
    602
    sprashanthk
    Aug 24, 2011
  5. govuser1
    Replies:
    0
    Views:
    595
    govuser1
    May 27, 2012
Loading...

Share This Page