Query based on "keyword" entered in a textbox

[Allan Skyner]

Hi all

I have a table which lists 10,000 product codes and descriptions, the
descriptions have been written in no particular order or standard. Therefore
what I would like to do is build a query for users to enter a "keyword" in a
text box (or better still to narrow the search results 2 keywords in 2
textboxes and do an and/or search), that will search the product name and
produce a list of potential products.

E.G
Product 1. A4 Brown Envelope
Product 2. Non-standard envelopes white
Product 3. Envelopes white 10cm x 4cm
Product 4. Standard white envelope B5

A search using criteria "envelope" OR "white" would list all 4 products and
a search using criteria "envelope" AND "white" would list products 2, 3 and 4.

Any suggestions would be welcome as I searched through all potentail
possibilities already discussed here on the forum and can't find anything.

Thanks in anticipation

Allan

 

[xRoachx]

Hi Allan -- Try this site as a starting point, particularly "Building Queries
on the Fly"...

http://www.fontstuff.com/access/index.htm