IgnBan
04-09-2008, 05:48 AM
I have this query to extract the number of Audits conducted in current month;
SELECT Count(Audits.Audit_ID) AS NumberOfAudits, Month([Date]) AS [Month]
FROM Audits
GROUP BY Month([Date])
HAVING (((Month([Date]))=Month(Now())));
This Db is two years old. How can I extract just this (2008) current Month? I noticed that is I use this query it adds the two years.
SELECT Count(Audits.Audit_ID) AS NumberOfAudits, Month([Date]) AS [Month]
FROM Audits
GROUP BY Month([Date])
HAVING (((Month([Date]))=Month(Now())));
This Db is two years old. How can I extract just this (2008) current Month? I noticed that is I use this query it adds the two years.