Product Query Seach tool

[Simon]

I haev a query that is based on aproducts tabel that includes

ID Number
ProductCode
ProductName
Price

What i would like to do is build a query that will let me seach the
database of product, so if i need to know the price and had a product
code i can enter just the product code and it will then just dispaly
the prodcut with that code, but i also require teh qery to dispay a
few prodcuts if i just search by ProductName, for example is i typed
in LAPTOP it would bring up all the products with the word laptop in
it, but i it typred 'Dell Z1000 Laptop it would only bring up the
product that matchs it

Over all i need a qeryt to search a product list by Code and NAme

Thanks

Simon

 

[KARL DEWEY]

Try this ---
SELECT [ID Number], [ProductCode], [ProductName], [Price]
FROM [YourTable]
WHERE [ProductCode] Like "*" & [Enter Product Code or Name] & "*" OR
[ProductName] Like "*" & [Enter Product Code or Name] & "*";