Results 1 to 2 of 2
  1. #1
    jackthedog is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    3

    Adding a Field Name

    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!

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    "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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding 2 fields together
    By Craig Spencer in forum Access
    Replies: 2
    Last Post: 04-08-2011, 02:10 PM
  2. Adding columns that contain blanks.
    By Tony McGuire in forum Access
    Replies: 11
    Last Post: 05-31-2009, 12:58 PM
  3. Adding pdf to a field
    By Hannu in forum Access
    Replies: 3
    Last Post: 05-27-2009, 07:08 AM
  4. Adding Two Columns
    By arthura in forum Queries
    Replies: 6
    Last Post: 05-01-2009, 08:38 PM
  5. Adding a Manual Date
    By JimmyT in forum Database Design
    Replies: 1
    Last Post: 04-21-2009, 06:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums