CONTAINS function

J

JYOTI

Hi,
I would like an ACCESS query to search the database for
the given word(it will be different everytime).
Is it possible to use the 'CONTAINS' function to do this
in query?

Jyoti
 
G

Guest

You can search a field by using the following criteria -

Like "*"&[Enter your keyword]&"*"

You can search multiple fields at the same time and enter
keyword only once by putting the criteria for the second
and other fields on a separate criteria line for each.
 
G

Guest

Thanks.
-----Original Message-----
You can search a field by using the following criteria -

Like "*"&[Enter your keyword]&"*"

You can search multiple fields at the same time and enter
keyword only once by putting the criteria for the second
and other fields on a separate criteria line for each.
-----Original Message-----
Hi,
I would like an ACCESS query to search the database for
the given word(it will be different everytime).
Is it possible to use the 'CONTAINS' function to do this
in query?

Jyoti
.
Click to expand...
.
Click to expand...
 
Top