I have a table with several thousand accounts. They include some national accounts that have many branches. Each national account has an account number called [Natl Home]. Each branch has a separate branch account number called [branch]. Each record also has [Account Name] but it is the name of the individual branch only and they vary greatly.
I would like to create a query and add a calculated field entitled [Natl Name] and write an expression that says
If [Natl Home] is "123456" display "XYZ Company", If not "123456" display [Account Name]
This way I will get one field with the [Account Name] of any accounts that are not national and the headquarters name of any account that is national.
I'm a beginner and have tried several combinations based on some previous expressions but keep getting errors. TIA for any help!
I would like to create a query and add a calculated field entitled [Natl Name] and write an expression that says
If [Natl Home] is "123456" display "XYZ Company", If not "123456" display [Account Name]
This way I will get one field with the [Account Name] of any accounts that are not national and the headquarters name of any account that is national.
I'm a beginner and have tried several combinations based on some previous expressions but keep getting errors. TIA for any help!