syntax errors with criteria statement

[krc777]

I have the following statement entered in the query criteria section.

SELECT MAX(EDRMPeriod) FROM EDRAppC WHERE EDRMPeriod Between DateAdd("yyyy",-1,DateSerial(Year(EDRMPeriod),Month(EDRMPeriod)+1,1)) AND DateSerial(Year(EDRMPeriod),Month(EDRMPeriod)+1,1) GROUP BY EDRCHPlan

I am getting a syntax error. This statement runs fine and produces the results I want in Queryman.
Thanks for any help.
k

 

[FoFa]

What happens when EDRMPeriod = 12?