Hi Guys
The following query works fine but if the reason is blank then it also shows a record with blank reason and count=0
I don't want the blank reason to be displayed in the query.
Any help will be much appreciated.
Thanks
The following query works fine but if the reason is blank then it also shows a record with blank reason and count=0
I don't want the blank reason to be displayed in the query.
Code:
SELECT tbl_RMS_Paperless.[1stRefuseReason], Count(tbl_RMS_Paperless.[1stRefuseReason]) AS Times
FROM tbl_RMS_Paperless
GROUP BY tbl_RMS_Paperless.[1stRefuseReason];
Any help will be much appreciated.
Thanks