Count all records in a query?

[jmc86@mac.com]

How do I count all records in a query to include null values?

 

[jdraw]

What have you tried?
Null values in what?

Typical usage

SELECT Count(ProductID) AS NumberOfProducts FROM Products;

 

[jmc86@mac.com]

I tried to trick the null data because when I run the original count query all null data comes back as zero. Obviously, that didn't work and it still returned zero.

SELECT Reviwshttable.[ID], Reviwshttable.[Claimnum], Reviwshttable.[Precall], Count(Reviwshttable.Precall) AS CountOfPrecall, IIf([Precall]>-1,CInt(1),CInt(0)) AS [Pre Call Totl Count]
FROM Reviwshttable
GROUP BY Reviwshttable.[ID], Reviwshttable.[Claimnum], Reviwshttable.[Precall], IIf([Precall]>-1,CInt(1),CInt(0));

 

[isladogs]

To count all records in a query, you can use

DCount("*"."queryName")

Or to count those records matching filter criteria 'strCriteria', use

DCount("*"."queryName".strCriteria)

 

[almahmood]

You could use this too:

SELECT [ID], [Claimnum], [Precall], Count(*) AS [Pre Call Totl Count]
FROM Reviwshttable
GROUP BY [ID], [Claimnum], [Precall]

 

[jmc86@mac.com]

Just tried your formula and it was on the money!! Thanks