- Joined
- Dec 12, 2019
- Messages
- 1
- Reaction score
- 0
Hi, how to display zero value in blank fields of Cross Tab query? I have posted the SQL below, please help me out.
TRANSFORM Count(Status.[Received from XXXXXX On]) AS [CountOfReceived from XXXXXX On]
SELECT Status.[Batch No#], Count(Status.[Received from XXXXXX On]) AS [Total Of Received from XXXXXX On]
FROM Status
GROUP BY Status.[Batch No#]
PIVOT Status.[Present Status];
TRANSFORM Count(Status.[Received from XXXXXX On]) AS [CountOfReceived from XXXXXX On]
SELECT Status.[Batch No#], Count(Status.[Received from XXXXXX On]) AS [Total Of Received from XXXXXX On]
FROM Status
GROUP BY Status.[Batch No#]
PIVOT Status.[Present Status];