Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    92

    Unanswered: Pivot Table and Pivot Chart

    Hi everyone,

    I have a question to ask on the pivot table.

    I am using the data in my reservation table. But however, I have encounter the problem is that the data show "Number" instead of the "Text"

    Eg. The employee name and tool name . It reflect 1 and 2 in the table.

    However, my reservation table show the text of the employee name and tool name..

    Thank...

  2. #2
    Join Date
    May 2007
    Posts
    14
    Hi StevenE,

    Are you sure that the fields data in your reservation table really has text type?

    You can see the result of numbers (in PivotTable/Chart View) when field source is any ID. In datasheet view you can see text, but in Design View that field has number type. Check up your field type in Design View.

    Mariana

  3. #3
    Join Date
    May 2007
    Posts
    92
    Hi watermariana,

    The field I look up for the Employee ID.. That why I got the number.. Okay but how can I possible change into text coz that Employee ID is under one to many relationship.

  4. #4
    Join Date
    May 2007
    Posts
    14
    StevenE,

    You can create Query based on your main table and your table with stored names. In query you select Employee Name instead Employee ID. So you can start query in Pivot Chart /table View.

    Mariana
    Attached Thumbnails Attached Thumbnails primer.JPG  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •