CONTAINS function

  • Thread starter Thread starter JYOTI
  • Start date Start date
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
 
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.
 
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...
 
Back
Top