sql - I need to count those that are not selected -

sql - I need to count those that are not selected -

i have access 2003 table of employees. there 2 columns. first 1 site name , sec column status. next query string can count has status of "completed"

select employee.[site name], count(employee.eid) [number of completed] employee (((employee.[status])="completed")) grouping employee.[site name]

the question is: there sites not in list, sites no employee has "completed" status. need list them value 0. solution in access 2003 helps me. thanks.

you want conditional aggregation. in ms access, looks like:

select employee.[site name], sum(iif(employee.[status] = "completed", 1, 0)) [number of completed] employee grouping employee.[site name];

sql ms-access-2003