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?
|