Hi!
My table / query contains various fields including customer account numbers. I need to populate a new field (Sales Group) with a description that identifies a group of account numbers. E.g.:-
Accounts 34,76,88,93 equals Sales Group “USA Parent Customers”
Accounts 45,22,76,43 equals Sales Group “USA Non Parent Customers”
Accounts 89,54,23,66 equals Sales Group “UK Customers”
Any other account not listed above equals Sales Group “ROW” (Rest Of The World)
I’m sure I’ve done this before using an ‘if’ and ‘move’ statement, but I’ve not touched access for over a year and I’ve forgotten so much. Any ideas appreciated!