Query by Month-Year and with a Record Count Field

[0sprey]

The 'Parts' Table contains a Date Field called [PURDATE] which contains the date the part was purchased.

I need a query to display parts purchased as a function of year and month of the purchase :

YEAR_MONTH COUNT OF RECORDS
2018-JAN 596
2018-FEB 456


Any thoughts on how best to accomplish this ?

KMD

 

[SkipVought]

Select FORMAT(PURDATE, “yyyy-mm”), COUNT(*)
FROM [MyTable]
GROUP BY FORMAT(PURDATE, “yyyy-mm”)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein