Syntax error?

[justice8965]

Hey guys, can anyone tell me whats wrong with my syntax here? Not sure where I'm missing quotes, or whatever it is I'm missing...

PreviousAverage: iif([BeginDate] <= DateAdd("m", -12, Now()), 0, DLookup("[AverageforPeriod]", "qry12month", "[BeginDate] = DateAdd("m", -1, [BeginDate])")

The error is coming from DateAdd, the "m" specifically.

 

[namliam]

"[BeginDate] = DateAdd("m", -1, [BeginDate])")

You cannot wrap " inside ""
Either double " them or ' ...
"[BeginDate] = DateAdd(""m"", -1, [BeginDate])")
or
"[BeginDate] = DateAdd('m', -1, [BeginDate])")
or
"[BeginDate] = #" & DateAdd("m", -1, [BeginDate]) &"#")

Any of the three should work just fine, just hope you now understand what is going on...

 

[justice8965]

Yeah I see where my error was, thank you. Used your third suggestion and it works perfectly thanks a lot.