SQL Instruction

[gatarossi]

Dear all,

I'm trying to do a consult in ms access from excel, but in this
segment of SQL doesn´t work:

My problem is in: m and yyyymm, I have already put "m", 'm' but it
doesn´t work.

CStr(Format(DateAdd(m,(-[period]),CDate(Left([year_month],4) & " - " &
Mid([year_month],5,2))), yyyymm) & Mid([year_month],7)) AS Expr1

How can I solve this problem?

Thanks a lot!!!

André.