Grouping in MS Access

DarkManXY2G

Senior member
Dec 4, 2000
582
0
0
If I have a database and a table that contains a bunch of PO's (purchase orders), is there any way I can do a grouping on the month in the date. The PO date comes in as the regular time stamp (mm/dd/yyyy). This maybe a stupid question, but any help would be appreciated. Thanks.
 

Descartes

Lifer
Oct 10, 1999
13,968
2
0
select ponumber, month(podate) as po_month, count(*) as total_for_month
from purchaseorders
group by ponumber, po_month