I have a table Tbl_Computron. I would like to auto update the field "Business Units" in the table based on a condition being met in the "Account Hierarchy" field, with the following syntax: IIf([Account Hierarchy] Like "CEAA*","Invest ment Grade Capital Markets") The thing is, I have over five hundred codes that includes other series such as CEAA, CERB, CEFV etc. and that will have a different business unit other than "Investment Grade Capital Markets". How do I begin to write an iif or else code that will group this for me?
Like, if account hierarchy begins with the prefixes CEFT.... or CGHY or CVRT or CBTY, then Business units is "x'. Then when the series change, Business units will be something else.
Like, if account hierarchy begins with the prefixes CEFT.... or CGHY or CVRT or CBTY, then Business units is "x'. Then when the series change, Business units will be something else.
Comment