Product Query Seach tool

S

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
 
K

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] & "*";
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top