PhotoFrang
Programmer
Hello,
I want to create a query that will calculate the sales of each product per day. I have two forms, “Products” and “Sales”. In the Sales form, I have the fields, Product1, Product2, Product3 and Product4. Each one of them has the sold quantity for each sale. All for of these fields are related to the Products table, with the field ProductName. What I want to do is to calculate the sales of each product for each day, and then for each week. I don’t know how could I tell the query, for each ProductName in the Products form, look in the Sales form, to Product1, Product2, Product3, Product4, and if there is a match, add the QuantityofProduct, any one of each four (e.g. QuantityofProduct1 or QuantityofProduct2), to the already existing number of quantity sold. Then I want to create a pivotchart that will show all these information (ProductName, Week and Day of Sale, Quantity Sold).
Thank you very much. I hope you will be able to find out a solution.
I want to create a query that will calculate the sales of each product per day. I have two forms, “Products” and “Sales”. In the Sales form, I have the fields, Product1, Product2, Product3 and Product4. Each one of them has the sold quantity for each sale. All for of these fields are related to the Products table, with the field ProductName. What I want to do is to calculate the sales of each product for each day, and then for each week. I don’t know how could I tell the query, for each ProductName in the Products form, look in the Sales form, to Product1, Product2, Product3, Product4, and if there is a match, add the QuantityofProduct, any one of each four (e.g. QuantityofProduct1 or QuantityofProduct2), to the already existing number of quantity sold. Then I want to create a pivotchart that will show all these information (ProductName, Week and Day of Sale, Quantity Sold).
Thank you very much. I hope you will be able to find out a solution.