Access 2002
In a query I count the number of patients from each doctors surgery that fail a certain criteria. This works correclty displaying a count of the patients from each practice who fail. The problem I have is that very few people ever fail this, is there a way to display a zero for each practice who has no patients failing this criteria
the sql for the query is shown below;
In a query I count the number of patients from each doctors surgery that fail a certain criteria. This works correclty displaying a count of the patients from each practice who fail. The problem I have is that very few people ever fail this, is there a way to display a zero for each practice who has no patients failing this criteria
the sql for the query is shown below;
Code:
SELECT Count(ConsultsQueryLast.PatientIndex) AS NumberOfPatients, ConsultsQueryLast.PracticeID
FROM ConsultsQueryLast
WHERE (ConsultsQueryLast.Drug18 <> "")AND ConsultsQueryLast.Drug19 Is Null) AND ConsultsQueryLast.Drug12 Is Null)
GROUP BY ConsultsQueryLast.PracticeID;
