I have a union query that has 3 fields a Text field, Number Field and a Date Field. I need to have a parameter on the Date Field. I thought I would put a Where clause in each part of the union example
Select * from qry1
Where Date between [enter beg date] and [enter end date]
Select * from qry2
where date between [enter beg date] and [enter end date] and part = 'M'
I then want to have this Create a local table..
problem is i want just one set of prompts not 2...
I realize this is a very simple question...Any ideas would be really appreciated