This question is probably really simple for someone who uses Access regularly, however, my experience level is pretty basic.
I have created a query to pull all of our salespeople's production for a period of time. The table I'm referencing contains:
- Key #
- Sales people's "Name" (as well as supervisor names)
- Supervisor key #
My question is: In the query, how can I get the Supervisor's name to show rather than their key #?
Key Name Super #
1 Tom Jones 4
2 E Kline 4
3 J Doe 4
4 S Meyer 7
The query now would pull: Tom Jones, 4, rather than Tom Jones, S Meyer.