DB search any fields?

[Mark M]

Not sure exactly what I want here but I will describe it as best I can

Ive got a product list of approx 100,000 items all with unique codes and descriptions. What I want to do is be able to search any part of the code or description.

IE, on the following product

RF1814BX /C/B/G* Reference 18 x 14 Bass Drum w/o BB3

May need to search for :

a) RF18
b) 18 x 14
c) Bass drum
etc

So for b) if I typed in 18 x 14 it would bring up all the products that had 18 x 14 in the description

What program can do it, if any? Access? Excel?

Thanks for any help

Mark

 

[Mark M]

It might do, but the price list spans multiple tabs? Is there a way to change the advanced iptions on the seach function to default to within "workbook" and not just "sheet"?

Thanks

 

[Mark M]

You will have to change that everytime though wont you? Im looking for the quickest option if someone is on the phone or something we can find it ASAP.