Syntax Error (Missing Operator)

[AllusiveKitten]

Hi

I have a really simple Syntax Error regarding a date that is really giving me the irrates...... It's one of those things you just keep looking over the error.

Set db = CurrentDb()
lsql = "SELECT Tbl_EnvelopesReceived.Date, Tbl_EnvelopesReceived.EnvelopesReceived From Tbl_EnvelopesReceived WHERE (((Tbl_EnvelopesReceived.Date)'" & CDate(Txt_Date) & "'));"
Set lrs = db.openrecordset(lsql)
End Sub

I have tried everything different possibilty with the date and the error still occurs.

I would really appreciate some assistance in sorting this one out.

Thank you so much for your help

AK

[Killer42]

I'd suggest you display and carefully examine the value in lsql. You'll find that you are missing the operator (hence the error message) between the field name and the value, in your WHERE clause.

In other words, you are saying WHERE FIELD VALUE. It doesn't make any sense - you need to specify what sort of relationship you are expecting between them; equal, not equal, whatever.