I have a table (Statements)
2 of the fields are (ID) and (ReceivedOn) - date format short date
I would like to build a query to count the records ReceivedOn the current month.
ex: all of the September
I tried this but it gave me all of the records, not just September:
SELECT Count(Statements.ID) AS CountOfID
WHERE Exists (SELECT ID FROM Statements where DateDiff("m",ReceivedOn, Now)=0)