Access Query

[JohnM]

May seem simple but I'm new so bear with me

I have a database of equipment and I want to do a query where when you are
promted for the item name you nly have to put of the name in (if you do not
know fully what it is called)

I think you have to use something like - LIKE

but I do not know where to enter it on the query

thanks

john

 

[BruceM]

In query design view it is in the same place as the Criteria it sounds like
you already have. It may look something like this:

Like "*" & [Enter search term] & "*"

The following will limit the recordset to items that start with the text the
user entered:

Like [Enter search term] & "*"

 

[roccogrand]

One other point John, you can copy the same text into several criteria
fields if you have text of interest in more than one. Just move down a row
for each field and Access will look for the text in each one. I have one
query that has the criteria that Bruce offers in seven (7) different fields.

LDN

In query design view it is in the same place as the Criteria it sounds like
you already have. It may look something like this:

Like "*" & [Enter search term] & "*"

The following will limit the recordset to items that start with the text the
user entered:

Like [Enter search term] & "*"

May seem simple but I'm new so bear with me

I have a database of equipment and I want to do a query where when you are
promted for the item name you nly have to put of the name in (if you do
not
know fully what it is called)

I think you have to use something like - LIKE

but I do not know where to enter it on the query

thanks

john