syntax issue when searchin dates

[mike02]

Hey, I am having syntax issues, can someone please take a look.

MySelector is a Number

and cboMonthlyDate is a Date

Thanks.

sSQL = "SELECT InvestmentID FROM Matrix WHERE ClientID = & " MySelector " & And MonthlyDate = & " cboMonthlyDate " & GROUP BY InvestmentID ORDER BY InvestmentID;"
Set rst = db.OpenRecordset(sSQL)

[rpeare]

sSQL = "SELECT InvestmentID FROM Matrix WHERE ClientID = " & MySelector & " And MonthlyDate = #" & cboMonthlyDate & "# GROUP BY InvestmentID ORDER BY InvestmentID;"