MISSING ZEROS IN A QUERY

[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?

 

[S.Clark]

Implement Nz() to force the null to a zero.

test: Nz([fieldname],0)

 

[William]

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

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?

 

[Golfinray]

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

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

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?

 

[William]

Thanks!!
--
William

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

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

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?