query to find records

[trackmedic]

I'm having trouble with a query. I want a query that looks at a table and retrieves records according to a user defined input. Ex. I have a table with cargo items. out of all these items, i want my query to look up a user input. Such as, the user would input the word "pump". How can I get the query to look up all records with the word "pump" in it like water pump or pumping unit. I think I would use wild cards but I do not know how.

 

[Chris RR]

Look up "like" in access help.

 

[trackmedic]

Thanks, I tried to look up like in help but it will not find anything. Could you give me a little further?

 

[BrainDead]

Like "*" & [Forms]![formname]![inputbox]& "

This would be the criteria for the query.
It will bring back all records with whatever is put into the inputbox on your form.

HTH

 

[trackmedic]

Thanks braindead,

I put the string in but had a problem as you typed it. So I played around with it. It works!!!! Thanks to everyone who has helped, Access is a challenge for the biginner but with avenues like you, it really helps out.

[This message has been edited by trackmedic (edited 08-30-2001).]

 

[DJBummy]

You could run it directly from the query like this.

Like "*" & [Enter A Selection] & "*"