SQL PROBLEM?

[athos07]

i have this sql code

select a_lastname, a_firstname, subject
from master
where subject = %keyword%


it dosent work, i think the problem is in the WHERE clause.
what is the correct way to right the WHERE clause to search for any word in any field of the SUBJECT field.. thanks

 

[cmmrfrds]

The wildcard % is okay for Access 2000 in Access 97 it is *. Since subject is a text field you need quotes surrounding the search criteria.

select a_lastname, a_firstname, subject
from master
where subject = & "'%" & keyword & "%'"

'- put the sql statement in a string and execute the string.
Dim sql as string
sql = "select a_lastname, a_firstname, subject " & _
"from master " & _
"where subject = '%" & keyword & "%'"
debug.print sql

 

[athos07]

ey thanks

hope i can retrun the favor some day

athos

 

[krkX]

Try using:

select ... from ... where sibject like '%keyword%'

or

sql = "select ... from ... where sibject like '%" & keyword & "%'"