Report will not recognize field

JR · External Since: Apr 05, 2006 Posts: 19

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 · External Since: Mar 03, 2006 Posts: 1616

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

"JR" wrote:

> 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

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

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.

--
Duane Hookom
Microsoft Access MVP

"JR" wrote:

> 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