Report will not recognize field

[JR]

I am trying to customize a report by adding the employee's last name to the
title of the report. I am doing this by adding a label to the header, next
to the generic report title label, and making the value = the employee's last
name. It picks up the employee number, but not the last name. I have tried
making the label = other fields in the source table and I can get that to
happen to all but the LastName field.

Any clues as to what is not happening?

Thanks,

JR

 

[KARL DEWEY]

It sounds like the field is a 'Lookup' field. If so, you will need a lookup
table to join in your query.

 

[Duane Hookom]

It seems that you have used a Lookup field defined in your table. Most of us
consider this poor practice. You need to include the table and field that
actually stores the employee's last name.