Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    98

    Unanswered: Reports showing ID of Field query shows name of field

    I am trying to run graph on a report from query but what's happening is query shows name but report on graph shows ID'S of the field

    Below is my query

    SELECT tblMainTWTTPSheet.txtRootCause, Count(tblMainTWTTPSheet.txtRootCause) AS CountOftxtRootCause
    FROM tblMainTWTTPSheet
    GROUP BY tblMainTWTTPSheet.txtRootCause, tblMainTWTTPSheet.Date
    HAVING (((tblMainTWTTPSheet.txtRootCause) Is Not Null) AND ((Count(tblMainTWTTPSheet.txtRootCause)) Is Not Null) AND ((tblMainTWTTPSheet.Date) Between [Forms]![frmStratificationOfRootCauses]![startDate] And [Forms]![frmStratificationOfRootCauses]![endDate]));

    My bound coloum on main menu form and back end table is 1
    coloum count 2
    coloum width 0;1

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    As answered elsewhere:

    Sounds like you're using a lookup field:

    The Access Web - The Evils of Lookup Fields in Tables

    In this query you need to add the other table, joined on the ID field, and use the text field instead of the ID field.
    Paul

Posting Permissions

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