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
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