Here is my query that is built.
SELECT [Sales Data 2009].Retailer_Name, [Sales Data 2009].Sale_Total, [Sales Data 2009].Quantity_Sold, [Retailer List].State_Province
FROM [Sales Data 2009] LEFT JOIN [Retailer List] ON [Sales Data 2009].Retailer_Name = [Retailer List].Retailer_Name
WHERE...
I need help building a form. I want to build a form to have a user be able to filter a query by 2 criterias. One field is State and is displayed in the results. I have no problem there. The other field is date (I need to do a beginning and ending date) and date will not display in the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.