Modify a SQL statement to sort by QTR

Topic

New Reply

I would like to modify the SQL below to sort the count by QTR and user. Not sure how to do this… Any thoughts? Thanks…

SELECT Count(pndata_tbl.EIRID) AS CountOfEIRID, pndata_tbl.User, pndata_tbl.ClosedDate
FROM pndata_tbl
GROUP BY pndata_tbl.User, pndata_tbl.ClosedDate;

Reply | Quote

Replies

I assume that QTR means quarter. Do you want to group by quarter only or by year and quarter?

Reply | Quote

Yes it means quarter and I would like to sort by quarter and year. Thanks..

Reply | Quote

Try this:

SELECT Count(pndata_tbl.EIRID) AS CountOfEIRID, pndata_tbl.User, Format([pndata_tbl].[ClosedDate],”yyyyQq”) AS QTR
FROM pndata_tbl
GROUP BY pndata_tbl.User, Format([pndata_tbl].[ClosedDate],”yyyyQq”);

Reply | Quote

Works great Hans. Thank you so much!!!

Reply | Quote