troubleshooting Question

MS Access 2007 and Parameters with Union queries

Avatar of Michael Katz
Michael KatzFlag for United States of America asked on
Microsoft Access
20 Comments1 Solution609 ViewsLast Modified:
Hi Experts,

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]
union
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 20 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros