Blank Space to Zero

C

Chris

I have read many posts on converting a blank space to zero but cannot seem to
make it work. Here is the sql statement from my query, any suggestions.

SELECT qselKCCountYes.txtPlant, tblQuestions.QstnLvl1, qselKCCountYes.[Yes
Responses], qselKCCountNo.[No Responses], [qselKCCountN-A].[N/A Responses]
FROM [qselKCCountN-A] RIGHT JOIN (qselKCCountNo RIGHT JOIN (qselKCCountYes
RIGHT JOIN tblQuestions ON qselKCCountYes.[Main Section Number] =
tblQuestions.QstnLvl1) ON qselKCCountNo.[Main Section Number] =
tblQuestions.QstnLvl1) ON [qselKCCountN-A].[Main Section Number] =
tblQuestions.QstnLvl1
GROUP BY qselKCCountYes.txtPlant, tblQuestions.QstnLvl1, qselKCCountYes.[Yes
Responses], qselKCCountNo.[No Responses], [qselKCCountN-A].[N/A Responses]
ORDER BY tblQuestions.QstnLvl1;

Thanks
 
Top