forcing blank field

M

Mary

Hello,
I am making a table with counts of a certain class, for ex.:
Count Class
2 1
3 2
0 3
2 4

The trouble is the table just shows me
2 1
3 2
2 4
and I want to include the Class 3 null value. What is the command and where
is it used to include zero count fields in the table? Thank you so much for
any and all replies.
Best,
 
J

Jeff Boyce

Mary

You've posted in the "queries" newsgroup, so can we assume you are working
on a query?

You mention "making a table", but in Access, tables are data "buckets", not
the same thing as queries.

If you have a query, consider posting the SQL statement for that query ...
it isn't clear how you are deriving the "count" you mention.

By the way, I suspect the word "count" is a reserved word in Access ... if
you name a field "count", you may be confusing Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Klatuu

IMHO, buckets are fields, tables are the little Dutch boy carrying the
buckets on the stick over his shoulders :)
 
P

Philippe Perrault

I just had this same problem of a null count not being returned as a zero and
I needed a zero in order for the the calculations on my report to work
properly. So here is what I did:
Nz(Count([YourTable].YourField),0)

Just add the Nz( before the Count and the ,0) at the end of the expression
 
Top