I have an Excel spreadsheet i knocked up that searches text strings for key words and then returns a value dependent on what value is found.
e.g. if it finds "excl", "exclusive" or "Exc" it returns that the line item I'm looking at is an "Exclusive".
There are quite a few of these key words i am looking for and the report is being used and updated regularly as more data becomes available so there is now too much data for Excel to handle, therefore i want to build the same thing in Access but don't know how.
What i want ideally is to have a table of key words to search for and then in a second field the "grouping" that the line item should be assigned.
i can then write a query that says if the "Order Description" or the "PO Description" in Table A contains any of these words in Field 1 of Table B return the value in Field 2 of Table B? if that makes sense?
e.g. if it finds "excl", "exclusive" or "Exc" it returns that the line item I'm looking at is an "Exclusive".
There are quite a few of these key words i am looking for and the report is being used and updated regularly as more data becomes available so there is now too much data for Excel to handle, therefore i want to build the same thing in Access but don't know how.
What i want ideally is to have a table of key words to search for and then in a second field the "grouping" that the line item should be assigned.
i can then write a query that says if the "Order Description" or the "PO Description" in Table A contains any of these words in Field 1 of Table B return the value in Field 2 of Table B? if that makes sense?