Return value for NULL query results

[shank]

In the below, I'm counting orders with multiple product lines in table Temp. In table TEMP, there will be duped invoice numbers indicating multiple lines. When there's >1, no problem. When there's <=1, I can only get a return of NULL. I'm trying to display a value of 0 for both columns. What am I doing wrong?

SELECT Nz([Temp]![InvNo],0) AS InvNo, Nz(Count([Temp]![InvNo]),0) AS InvNoCount
FROM Temp
GROUP BY Nz([Temp]![InvNo],0)
HAVING (((Nz(Count([Temp]![InvNo]),0))>1))
ORDER BY Nz([Temp]![InvNo],0), Nz(Count([Temp]![InvNo]),0);

Thanks!

[ranman256]

make Q1 to convert all nulls to 0.
then use Q2 (which uses Q1) as the reporting query.

[shank]

Understood.

Thanks!

[shank]

I needed to come back to this. Now I'm having issues getting a value if a field is either "" or IsNull.

All the below statements give me no results.

InvCount: IIf([InvNoCount]="" Or IsNull([InvNoCount]),0,1)

InvCount: IIf([InvNoCount]="" Or IsNull([InvNoCount])=True,0,1)

InvCount: Nz([InvNoCount],0)

What am I doing wrong?

Thanks!