Problem with a report

[renegp55]

I have an ACCESS database that I use to track our employees who 'graduate" from our training programs. I used the lookup wizard in the field used for their assigned dept. Problem I have is that when I create a report to list graduates by dept I get the ID# back instead of the dept's name...any ideas how can I solve this problem. When I run the query I can see the dept's name but when create report based on that query I get the Dept's ID# back... Any help will be greatly appreciated...

[jzwp11]

You will have to include the department table in the report's record source in addition to the table(s) that are already in the record source. BTW, even though Access has the capability of having lookup fields in the table, it is generally not recommended. Having them causes problems just as you describe but others as well as indicated on this site.

[renegp55]

I have an ACCESS database that I use to track our employees who 'graduate" from our training programs. I used the lookup wizard in the field used for their assigned dept. Problem I have is that when I create a report to list graduates by dept I get the ID# back instead of the dept's name...any ideas how can I solve this problem. When I run the query I can see the dept's name but when create report based on that query I get the Dept's ID# back... Any help will be greatly appreciated...

Worked Perfectly!!!!!!!! Thank you very much for the help...Muchas Gracias....

[jzwp11]

You're welcome.