Help with a Report

[zaps via AccessMonster.com]

Hi there. I'm hoping someone can help me out. I have created a report that
groups on Employee Number. The report works fine, but I would like to have
the report show the Employee Name beside the Employee Number. The problem is
the Employee name comes from a look up table. It's not the same table that
the report is based on. I would like to pull the Name from the look up table
that corresponds with the Employee Number on the report? Any ideas I can try?


Thanks,
Zaps

 

[Duane Hookom]

Add the lookup table to your report's record source and join the appropriate
fields. You can then add the employee name field(s) to your report's field
list.