Help with sql query in Access 2007

[JackLeon]

I had been using the following query since a while in my access form and it was working fine till now.. but now I am getting error "Too few parameters. Expected 1"



sqlGrpCd = "SELECT Group_Id FROM Tbl_Payment_Group Where Trim(Eff_Dt) <> '' and Exp_Dt >= " & Date & " ORDER BY Group_Id DESC"
Set rsGrpCd = CurrentDb.OpenRecordset(sqlGrpCd, dbOpenSnapshot)

On further analyzing, I found that the query piece "and Exp_Dt >= " & Date & "", is the cause for error. The Date comes out as '15-Oct-15' and the query on execution, looks like:

select Group_Id from Tbl_Payment_Group where trim(eff_dt) <> '' and Exp_Dt >= 15-Sep-15 order by Group_Id Desc

Table Data looks like:
Group_Id: Rate: Eff_Dt: Exp_Dt
G1: 1100: 01-Oct-15: 30-Dec-15

and Table structure as:
Group_Id - Text
Rate - Number
Eff_Dt - Date/Time
Exp_Dt - Date/Time

Please advice. TIA.

[pbaldy]

Either move the Date function inside the quotes or surround the value with #.

[JackLeon]

Thanks bro, it worked!! But what will still trouble me is that I did this code around 2 years back and have been using it since then but it never gave me any trouble till now.. the only change I see, from the last time I accessed my application, is, that I upgraded my operating system to Win 10.

anyway, thanks a lot for your help

[pbaldy]

Happy to help! I'm surprised it worked as it was.

[JackLeon]

Yup, confirmed. It has to be Win 10.. tried the same code on my other machine with Win 7 and it worked fine. It seems, that encasing Date field with a # was not mandatory earlier but with the new upgrade, it will have to be done anyhow.

[pbaldy]

Interesting. Maybe your format let you get away with it. # has always been required with dates like 9/16/2015.