I'm new to 'union' queries and need some help, please, with creating queries that span tables.
I have six tables. The first four, call them 'Sales_Master', have identical structure with these fields: Sales-ID, Product_ID, Quantity, and MMYYYY. Each of these tables represents a month's worth of sales transactions for each Sales_ID (e.g., s100, p123, 10, 022019). The fifth table is 'Product_Master' and contains Product_ID, Product_Name (e.g., p123, pname123). The sixth table is 'Person_Master' and contains Sales_ID, Sales_Name (e.g., s100, sname100).
Is it possible for an Access query to answer the following question: What is the average quantity sold for each sales person for each product over last three months, assuming sales data is available for months 202019, 012019, and 122018?
I have other similar questions that span the sales monthly tables, and I hope any help I get here will get me started on Access 'union' type queries. Thanks.
I have six tables. The first four, call them 'Sales_Master', have identical structure with these fields: Sales-ID, Product_ID, Quantity, and MMYYYY. Each of these tables represents a month's worth of sales transactions for each Sales_ID (e.g., s100, p123, 10, 022019). The fifth table is 'Product_Master' and contains Product_ID, Product_Name (e.g., p123, pname123). The sixth table is 'Person_Master' and contains Sales_ID, Sales_Name (e.g., s100, sname100).
Is it possible for an Access query to answer the following question: What is the average quantity sold for each sales person for each product over last three months, assuming sales data is available for months 202019, 012019, and 122018?
I have other similar questions that span the sales monthly tables, and I hope any help I get here will get me started on Access 'union' type queries. Thanks.