A simple SQL clause

giannis · Sep 7, 2003

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 · Sep 7, 2003

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

A simple SQL clause

giannis

Arvin Meyer