• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Grouping in MS Access

D

DarkManXY2G

Senior member
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.
 
select ponumber, month(podate) as po_month, count(*) as total_for_month
from purchaseorders
group by ponumber, po_month
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top