Lookup?

Karjoe

Registered User.
Local time
Today, 02:01
Joined
Sep 9, 2011
Messages
11
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 instead of the intial.
The name and the intial are stored in a table that's updated by a user. How
can I make the report or rather the query linked the report get updated
whenever a new exec is entered into the table?

Thanks in advance.
 
You would have both the "data" table and the "lookup" table in the query, joined on the common field. That enables you to include the name as a field available on the report.
 
Linkded the lookup table and worked. Thank you.
 

Users who are viewing this thread

Back
Top Bottom