sql-server - 3061 Too few parameters.Expected1

Question

I am getting the Error two few parameters Expected 1.For the below query which I am using in MS Access vba code .I am able to point that Where clause is the reason I am getting this error.But not sure why.

strSQL ="SELECT Count(*) FROM  Table_1 INNER JOIN Table_2 ON (Table_2.[F6] = Table_1.[Column1]) WHERE ( (Table_1.[Table1_Date])> DateAdd(month,-1,Date()) );"
    
Set rs = MyDB.OpenRecordset(strSQL)

标签： sql-serverinner-joinms-access-2016