Replace ID with Name Field

[chellebell1689]

Hello,
I have a report that filters members by their type. On the form there is a field that shows the member's class they are assigned to, but currently it shows the class ID and I want it to show the actual class name. How do I make the report show the actual name instead of the class ID? I know it's a simple fix, but I've only done that once and it was MONTHS ago! (And I'm still kinda new to Access).

Thanks in advance for the help.

 

[Ranman256]

in the report query,
Join the table to your tMemberClass table on ClassID field.
bring down ClassName into the query

 

[chellebell1689]

Yay that worked!! Thank you!! I knew it was something easy like that! X-D