I know that this probably a daft question but someone please tell me where to place the # when enclosing a date for access.

My problem is with the following:

strSQL = "Select * from JobDate where OrgDt = '" & _
        'CStr(Request.Form("cboOrgDt")) & "'"

I have tried all manner of things without any success and would be very grateful for a little help.

Thanks

Paul

Its: #Date#

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature