One filter for 3 Queries in Union Query

[rlsublime]

I currently have a union query with 3 queries linked to it. There is a “Start’ and “End” date filter for all three queries. The start and end date filters pop up three times(One for each query). I am trying to only get it to pop up once but to apply the filter to all three queries in the Query Union.

[ssanfu]

I currently have a union query with 3 queries linked to it. There is a “Start’ and “End” date filter for all three queries. The start and end date filters pop up three times(One for each query). I am trying to only get it to pop up once but to apply the filter to all three queries in the Query Union.

Put 2 text boxes on a form. Modify the 3 queries to look at the text boxes. You will have to concatenate the controls in each of the queries.

ie ..... WHERE StartDate = #" & Forms!SomeForm.dtStart & "# AND EndDate = #" & Forms!SomeForm.dtEnd 7 "#"

(dtStart is the name of the control for the start date
dtEnd is the name of the control for theend date.)

[rlsublime]

Thanks. I am fairly new to access so I might need a little additional help. So far, I created a form named DateFilter with two text boxes and named one dtStart and the other dtEnd. I then put the following “WHERE StartDate = #" & Forms!DateFilter.dtStart & "# AND EndDate = #" & Forms!DateFilter.dtEnd & "#" in each of the three queries under the date that is to be filtered. Should I create some king of button in the form to execute the UNION query?

Thanks

[ssanfu]

How are you executing the query now? As long as the form is open and the date text boxes have entries, you can execute the query as normal.