10-27-14, 16:07 #1Registered User
- Join Date
- May 2014
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 ?
10-27-14, 18:17 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
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:
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