If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple filters using combo box
Hi,
I'm trying to figure out how to filter a query using the following criteria: Start Date and End Date Plus Issue or All Agent or All Rep or All In each combo box I have the following: SELECT [tbl_Issue].[Issue] FROM tbl_Issue union select ' All' FROM tbl_Issue ORDER BY [Issue]; etc. In the query I have the following: Date: =[Forms]![frmselector]![txtStartDate] And =[Forms]![frmselector]![txtEndDate] Issue: Like [Forms]![frmselector]![Issue] etc. However, I get a blank query. What am I missing? |
Thread Tools | |
Display Modes | |
|
|