Search for words in a record

[Caravatis]

Question: Say I had a text field in a record and I wanted to search for
words within that record (but not necessarily in the order they are
recorded). For example, I would have a field that contained the text:

"30" x 79 1/4" 5 Panel door"

And I would want this record to be returned when I searched for (30" Door)
or (5 panel door) or (30" 5 panel), using a user input parameter query.

Any help would be greatly appreciated.

 

[Golfinray]

I think you would need several fields. One for door height. One for door
width. One for number of panels, etc. Then in the criteria below each field
you would put under door height [enter door height]. Under width you would
put [enter door width]. Under panels put [enter number of panels]. Use the
number of fields you need and it will ask you each in turn.

 

[Jeff Boyce]

By combining all those separate "facts" (dimension, design, product) in a
single field, your search is MUCH harder that if the data were structured as
a typical database (one fact, one field).

One approach MIGHT be to use the "Like" operator and the "*" wildcard
character, but getting it to find that specific record for any of those
three possible input criteria is going to be ... work.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP