Union Query with parameter for results by month

[Archie1]

Hi Again
How would I go about adding a date parameter to my union query? My required end result is a report that would prompt me for the month ie "June"

 

[sxschech]

You would need to add the parameter to both select statements, or you could do this and then you will be able to use the graphical interface to add your parameter and only need to do it once.

SELECT xyz.*
FROM ( --your union query goes here --) AS xyz

Then you can switch to design view and add parameters as if it were a normal select query. Change xyz to a more meaningful name.