R
roystonteo via AccessMonster.com
I have 1 table with 1 whole year of data.
date, partno, qty, price
Scenario is that the 1 part might have sold several times in each month.
How can i sum all the monthly records and form a query like this:
date partno qty totalprice
Jan-09 #1213 1000 200
Feb-09 #1232 1000 200
Mar-09 #1242 1000 200
date, partno, qty, price
Scenario is that the 1 part might have sold several times in each month.
How can i sum all the monthly records and form a query like this:
date partno qty totalprice
Jan-09 #1213 1000 200
Feb-09 #1232 1000 200
Mar-09 #1242 1000 200