I'm keeping a table of numbers products sold daily by different categories. I want to be able to calculate the sum of all the products in all categories sold by day, month, and year. Three calculations. Sales are entered into each category daily by date through an access form. The data is stored in a table by date and category. How would I do the calculations in a query or in a report.
Thank,
You
Thank,
You