Grouping and Counting null records

  • Thread starter Thread starter TomC
  • Start date Start date
T

TomC

I am sorting and grouping on Field A using the =Count(*) function. Field A
has null values and these records are being ignored. How do I get the total
of null/blanks to print??? Thanks in advance for any help. Tomc
 
It seems to me that Count(*) should count every record while Count([Field A])
would return a count of records with a value in Field A.
How about:
=Count(1)
 
Thanks, that helped me.

Duane Hookom said:
It seems to me that Count(*) should count every record while Count([Field A])
would return a count of records with a value in Field A.
How about:
=Count(1)

--
Duane Hookom
Microsoft Access MVP


TomC said:
I am sorting and grouping on Field A using the =Count(*) function. Field A
has null values and these records are being ignored. How do I get the total
of null/blanks to print??? Thanks in advance for any help. Tomc
Click to expand...
Click to expand...
 
Back
Top