PC Review


Reply
Thread Tools Rate Thread

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

 
 
New Member
Join Date: May 2012
Posts: 2
 
      14th May 2012
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS ACCESS -- Help with query code filtered by option groups and check boxes govuser1 General Software 0 27th May 2012 06:02 PM
Search Check Boxes on a Form Using Check boxes on a search Form rsw1984 Microsoft Access VBA Modules 16 29th Aug 2008 08:50 PM
Make check boxes look like radio check boxes? AAaron123 Microsoft VB .NET 2 24th Apr 2008 02:24 AM
i have two query q1, q2.both query use sub query.can i join both =?Utf-8?B?bmlraGls?= Microsoft Access Queries 1 7th Aug 2007 06:44 AM
How do i create a value for check boxes or option boxes =?Utf-8?B?VGltIHdy?= Microsoft Excel Misc 1 9th Feb 2006 11:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.