forcing blank field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
IMHO, buckets are fields, tables are the little Dutch boy carrying the
buckets on the stick over his shoulders :)
 
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
 
Back
Top