Can A Sort be Done by Keyword?

[Miracle]

Hey, Thanks to all for this awesome forum! It already has been a help.
I am wondering if it is possible to sort by keyword groups. Another
words, I have 2500 items in the access database with product
information and such that are spread out over 18 columns. I would like
to sort this database by doing a "search and sort" (I made that term
up) by certain keywords that are in the "caption" column. Is such a
thing possible?

Thanks in advance..

Chris

 

[Ken Snell]

Probably.... but you need to provide a bit more info.

Likely what you're wanting is a series of "Like" statements as the criteria
expression:

[Caption] Like "Keyword1*" or [Caption] Like "Keyword2*"

etc.