QUERY PROBLEM

[Guest_imported]

This query


"SELECT DETAILS.* FROM DETAILS WHERE DETAILS.FIRST LIKE 'A*';"

is takin A* as a literal instea of searching the database for DETAILS.FIRST that starts with 'A' when run from VBA.
The same query works fine when run from access.
Help me out on this
Thank you

 

[fmbpcsup]

the following:

"SELECT * FROM DETAILS WHERE FIRST LIKE " & chr(39) & "A*" & chr(39)

will get the string constructed as VBA needs it