Report will not recognize field

  • Thread starter Thread starter JR
  • Start date Start date
J

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
 
It sounds like the field is a 'Lookup' field. If so, you will need a lookup
table to join in your query.
 
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.
 
Back
Top