-
When the record I want to return contains a # in the criteria the recordset returns no records
for instance cFind = "Jones Store #1" or
cAddr = "6151 Freeport Blvd. #180"
SQL$ = "select [Company], [Address1], [Address2], [City State Zip] from [ShipTo] where [Company] like '" & cFind & "' and Address1 like '" & cAddr & "'"
Data3.RecordSource = SQL$
Any ideas on how to get it to recognize and return the records will be much appreciated.
Thanks!
-
Have you tried this?
SQL$ = "select [Company], [Address1], [Address2], [City State Zip] from [ShipTo] where [Company] like '[" & cFind & "]' and Address1 like '[" & cAddr & "]'"
------------------
Marty
-
I may have missed what you were getting at, but I think the # is a 'key' symbol in Access SQL. It is usually enclosed around dates and therefore may not be able to be used in the way you are attempting
Cheers Dave
aka Lil Dave
