Hi,
I have a field in a report that I update manually whenever we a new account
exec is added. it's like this:
If([Acct exec]="FM","Frank Min")If([Acct exce]="JP", "John Pepp",,,,,etc
Next time I have a new acct exce (MM) I update the report manually to show
the full name of the acct exec...