I am new to access and trying to convert an excel model to access.
Is it possible to create a calculated field in a query that would give the total by month for a particluar product?
For example, Item 1 sold 35 units in January, 45 in Feb, 50 in March.
I would want to see something like this
Date Qty Total for Month
1/1 20 35
1/5 10 35
1/31 5 35
2/2 20 45
2/8 15 45
2/2 10 45
3/1 20 50
3/4 20 50
3/25 10 50
Any ideas would be greatly appreciated. Thank you!