Grouping and Counting null records

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
 
D

Duane Hookom

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)
 
T

TomC

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting records that are not null 4
Trouble with my sorting and grouping 2
How do I sort a report grouping on a calculated value? 8
How to count consecutive records base on 2 groupings 0
Help me count records without duplicates 3
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
Sorting on the value of a text box in each record? 2
How to count records using count(*) in a chart report 3

Top