Wow my second post and I still need help!
Working on a customer management dbase and I wrote my first ever SQL query today! The query I wrote is a union query as follows:
SELECT CustomerAdvisor, Outcome, SoldDate, SoldSameMonth, Product, LeadSource
FROM [2_AppointMasterSELECT_DRIVEWAYS Query]
UNION ALL
SELECT CustomerAdvisor, Outcome, SoldDate, SoldSameMonth, Product, LeadSource
FROM [2_AppointMasterSELECT_PRODUCTS Query]
UNION ALL SELECT CustomerAdvisor, Outcome, SoldDate, SoldSameMonth, Product, LeadSource
FROM [2_AppointMasterSELECT_SOLAR]
What I am trying to figure out now is how to put in a couple of filter criteria, so as when the query is run it asks for specific criteria, on the following common fields:
CustomerAdvisor (a single value), SoldDate ('From'-'To' dates)
Any help is appreciated.
David