Counting a months worth

[Charmed7]

I have been through this board looking for an answer, I've come close but not quite getting it.

I (obviously) need to count how many records each user has completed (easy)

I need to count how many they did in a months time. I need to report multiple months in one report.

A little back ground on me...I only know the Query Design view and it's pretty limited. I have tried to move into the SQL view and alter the information there but it's not working in my favor. I also tried changing the format in the date properties to mm/yy but it's still sorting by the full date and time.

Any help would be awesome. Here's a copy of the SQL statement if it's easier to just change it there. Thanks in advance for the help.


SELECT Count(qry_QuotesIssued.Quote_Number) AS CountOfQuote_Number, qry_QuotesIssued.FName, qry_QuotesIssued.Creation_Date
FROM qry_QuotesIssued
GROUP BY qry_QuotesIssued.FName, qry_QuotesIssued.Creation_Date;

 

[pbaldy]

Untested, but try:

SELECT Count(qry_QuotesIssued.Quote_Number) AS CountOfQuote_Number, qry_QuotesIssued.FName, Format([Creation_Date],"mm/yy")
FROM qry_QuotesIssued
GROUP BY qry_QuotesIssued.FName, Format([Creation_Date],"mm/yy");

 

[Charmed7]

Holy (insert swear word here)!!! It works.

It's the Group By Format part that made it work. How do you learn these things. Thank you so much for the help. It's greatly appreciated.