A simple SQL clause

[giannis]

I have the SQL clause :

SELECT * FROM Table WHERE F Like "*"+"a"

This clause is correct; but I must insert this in a VB code as :

Forms!myform.RecordSource= (SQL clause)

How can write this?

I tried this but i receive error message (syntax error)

Forms!myform.RecordSource = "SELECT * FROM Table WHERE F Like " & "'*'" & "
+ " & "'a'""

 

[Arvin Meyer]

You need to use:

"SELECT * FROM Table WHERE F Like '*a'"

which will select everything in the Table where the data in field F ends
with the letter a
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access