I am creating a report that pulls from a table which has a column called "Name". On the report header i would like to show Division Name - Market Name - Manager Name so i have an expression that goes something like..

=[DVSN_NM] & " - " & [MKT_NM] & " - " & [Name]

Everything seems to come out correctly but the [Name] shows the report file name instead of pulling from the table to show the Manager Name. I tired doing [table_name].[Name] and it still doesn't work.

Can anyone help?

Thanks!

"Name" is a reserved word in access and you should not use if as the name of a field or control. That is the reason that it is returning the "Name" of the report.

Have a look here

__________________
Regards,

John A