MISSING ZEROS IN A QUERY

  • Thread starter Thread starter William
  • Start date Start date
W

William

I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where there are no ETs, the field in the count column is blank instead of a
zero. I need it be a zero. Why is the field blank and what can I do to have
the query return zero?
 
Thanks for this. I am enough of a beginner, however, that I need a little
more explicit directions. Where does Nz([fieldname],0) actually go?
--
William


S.Clark said:
Implement Nz() to force the null to a zero.

test: Nz([fieldname],0)

William said:
I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where there are no ETs, the field in the count column is blank instead of a
zero. I need it be a zero. Why is the field blank and what can I do to have
the query return zero?
Click to expand...
Click to expand...
 
You would put that in a new column of your query and name it whatever you
want like this
Line with zeroes: nz([the name of the field])

William said:
Thanks for this. I am enough of a beginner, however, that I need a little
more explicit directions. Where does Nz([fieldname],0) actually go?
--
William


S.Clark said:
Implement Nz() to force the null to a zero.

test: Nz([fieldname],0)

William said:
I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where there are no ETs, the field in the count column is blank instead of a
zero. I need it be a zero. Why is the field blank and what can I do to have
the query return zero?
Click to expand...
Click to expand...
Click to expand...
 
Thanks!!
--
William


Golfinray said:
You would put that in a new column of your query and name it whatever you
want like this
Line with zeroes: nz([the name of the field])

William said:
Thanks for this. I am enough of a beginner, however, that I need a little
more explicit directions. Where does Nz([fieldname],0) actually go?
--
William


S.Clark said:
Implement Nz() to force the null to a zero.

test: Nz([fieldname],0)

:

I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where there are no ETs, the field in the count column is blank instead of a
zero. I need it be a zero. Why is the field blank and what can I do to have
the query return zero?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top