How to display zero value in blank fields of Cross Tab query

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];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top