423,323 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,323 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:
Expand|Select|Wrap|Line Numbers
  1. TRANSFORM Count([Prime-Tbl].[TD_Install date]) AS [CountOfTD_Install date]
  2. 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]
  3. FROM [Prime-Tbl]
  4. GROUP BY [Prime-Tbl].ECP_NO, [Prime-Tbl].[TD#], [Prime-Tbl].[TD_Install date]
  5. 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.