CONTAINS function

[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

 

[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.

 

[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
.

.