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

    Unhappy Unanswered: Query Giving ID instead of Text in report

    SELECT Count([Unsafe Act ].[Tag]) AS [CountOfTag], [Unsafe Act ].[Audit], [qryTag].[Tag]
    FROM [Unsafe Act ] LEFT JOIN [qryTag] ON [Unsafe Act ].[Tag] = [qryTag].ID
    WHERE ((([Unsafe Act ].Date) Between [Forms]![frmSafetyReportOut]![startDate] And [Forms]![frmSafetyReportOut]![endDate]))
    GROUP BY [Unsafe Act ].[Audit], [qryTag].[Tag]
    HAVING ((([Unsafe Act ].[Audit])=[Forms]![frmSafetyReportOut]![cboConditionAct]))
    ORDER BY Count([Unsafe Act ].[Source Of Tag]) DESC;

    I am trying to run this query and query works fine however I am trying to run a chart on the report which shows ID's of Tag instead of txt of Tag

    Can anyone see What I am doing wrong ?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    It sounds as if you're talking about a Lookup Field in a Table which is considered to be a very bad idea by many experienced Access developers! For the reasons why read the article "The Evils of Lookup Fields in Tables" here:

    http://mvps.org/access/lookupfields.htm

    Note that this refers to Lookup Fields/Comboboxes in Tables not to Comboboxes in Forms, which is something else all together.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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