Report will not recognize field

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
 
K

KARL DEWEY

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top