Missing Null Value in Query

[GATJA]

Yes, another of my query troubles. I am running a query that is showing the number of demos booked, number of demos executed, then the percentage of demos executed. I have 2 demos that have 1 or 2 booked, but they have not been executed. They should show up in the query so I can get a percentage for them, but they do not. Here is my SQL:

SELECT [Promo count].PromoNo, [Promo count].[# of Demos], Count(Query6.Status) AS CountOfStatus, IIf([CountOfStatus]=0,0,[CountOfStatus]/[# of Demos]) AS Percentage
FROM [Promo count] INNER JOIN Query6 ON [Promo count].PromoNo = Query6.PromoNo
WHERE (((Query6.Status)="E"))
GROUP BY [Promo count].PromoNo, [Promo count].[# of Demos];

Anyone know what may be going on?

 

[edtab]

I take it that "E" means executed.
If so, then your query will only select those that
have been executed and nothing else.

If you want to show everything including the ones
that have not been executed, then you have to take
out your condition in the WHERE clause.