Allowable text phrases
Posted on 2011-05-10
I am working with a large table with Federal Express and American Express transactions. I am trying to group the transactions based on a few of the fields. And based on what's in there I want to create a Category item/field. For example, the new field is Category. If "ship" or "ABC Co." or "XYZ" exists inside the "Shipper" field, I'd like to assign "Cost of Goods Sold", if "Expedia" or "Travelocity", I want it to say "Travel". I'd like to have a table somewhere with two columns, one for search text and one for assignToCategory. Then, in this query, I'd search the field on each record through this other table and return the value. I'd like to make it easy on myself and just be able to add values to the table. Does anyone know how I could approach this?