azhar2006
Registered User.
- Local time
- Today, 08:15
- Joined
- Feb 8, 2012
- Messages
- 202
I have a select query that calculates the Count of certain and gives me the result of the sum of each specialty. Some records are empty and there is no specific specialization. What I want is to calculate these empty fields as well.
Code:
SELECT tblMastr.adjAppo, Count(tblMastr.adjAppo) AS CountOfadjAppo
FROM tblMastr
GROUP BY tblMastr.adjAppo;