422,764 Members | 1,289 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,764 IT Pros & Developers. It's quick & easy.

Convert crosstab output value from 0 and 1 to X

P: 1
It has been many years since I have worked in Access. I feel like a new user. I have created a crosstab query to display information in a user friendly manner however, the output needs to read as "X". Can someone help? SQL:

TRANSFORM Count([Prime-Tbl].[TD_Install date]) AS [CountOfTD_Install date]
SELECT [Prime-Tbl].ECP_NO, [Prime-Tbl].[TD#], [Prime-Tbl].[TD_Install date], Count([Prime-Tbl].[TD_Install date]) AS [Total Of TD_Install date]
FROM [Prime-Tbl]
GROUP BY [Prime-Tbl].ECP_NO, [Prime-Tbl].[TD#], [Prime-Tbl].[TD_Install date]
PIVOT [Prime-Tbl].ECP_PLATFORM;
Oct 10 '17 #1
Share this Question
Share on Google+
1 Reply


Narender Sagar
100+
P: 189
Hi, I think your question is not clear enough. What do you mean by "the output needs to read as "X"."..?
Oct 13 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.