Probably really simple but..

  • Thread starter Thread starter Jack McGuigan
  • Start date Start date
J

Jack McGuigan

Hi all,

I haven't used Access for yrs and now need to create a query quickly. I
have a table, in which some of the fields have long data strings. I simply
need to create a query which will look through the table and filter all
records which contain the word "potato". I can even be specific and say
which fields it could be in.

I just need to create another table or just filter the existing table for
records which have fields which contain "potato"

Help?
 
in the query builder, under the field you wish to evaluate, put...

like "*potato*"

if you wish to search more than one field, put the criteria under each
field, but put it on a SEPARATE LINE. This creates an "or" statement.
putting it on hte same line in the query builder would require that "potato"
exist in all the fields being evaluated.

Rick B



Hi all,

I haven't used Access for yrs and now need to create a query quickly. I
have a table, in which some of the fields have long data strings. I simply
need to create a query which will look through the table and filter all
records which contain the word "potato". I can even be specific and say
which fields it could be in.

I just need to create another table or just filter the existing table for
records which have fields which contain "potato"

Help?
 
Hi all,

I haven't used Access for yrs and now need to create a query quickly. I
have a table, in which some of the fields have long data strings. I simply
need to create a query which will look through the table and filter all
records which contain the word "potato". I can even be specific and say
which fields it could be in.

I just need to create another table or just filter the existing table for
records which have fields which contain "potato"

Help?
Click to expand...

If the word searched for is in just one Field, then as Where clause in
the query SQL:

Where [FieldName] Like "*" & [enter word] & "*"

If the word can be in one or more fields, then:
Where [FieldName1] Like "*" & [enter word] & "*" OR [FieldName2] Like
"*" & [enter word] & "*" Or [FieldName3] Like "*" & [enter word] & "*"

You will be prompted, just once, for the search word.
 
Back
Top