Dependent Label

[lugnutmonkey]

I have a report that shows the calls recieved for a department selected within a form.

In order to label the report properly i Have a text box with with the data source of =[Department Name]

In most of the reports this returns the proper value. however in some of my newer reports the value returned is the Department ID which is completely meaningless to anything but the database itself.

Anybody have any idea why this is happening. I have tried using the Expression builder within the control source field to select various places that might hold the name. I have had no success with this method.

Any suggestions or answers are apprecciated.

Thanks

[pbaldy]

It's a guess, but is it a lookup field? If so, see # 5:

http://access.mvps.org/access/lookupfields.htm

[lugnutmonkey]

WHERE ((([DPC_REP_Y:Y2].Representative)=[Reports]![DPC_DEPT_M:M]![Representative]))