RE: MISSING ZEROS IN A QUERY

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks!!
--
William


"Golfinray" wrote:

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" wrote:

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" wrote:

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

test: Nz([fieldname],0)

"William" wrote:

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
.

Relevant Pages

  • RE: MISSING ZEROS IN A QUERY
    ... I am enough of a beginner, however, that I need a little ... more explicit directions. ... the query returns a count of a two-letter code. ... I need it be a zero. ...
    (microsoft.public.access.queries)
  • RE: MISSING ZEROS IN A QUERY
    ... You would put that in a new column of your query and name it whatever you ... Line with zeroes: ... "William" wrote: ... I need it be a zero. ...
    (microsoft.public.access.queries)
  • Re: Conditional printing of records in the detail section of a rep
    ... I got sick, still sick, so I'm putting this on hold for the moment. ... In query design, type an expression like ... sums the numbers from approximately 35 numerical fields ... The default data is zero. ...
    (microsoft.public.access.reports)
  • Re: Conditional printing of records in the detail section of a rep
    ... The query option, as outlined in your post, doesn't work. ... The default data is zero. ... commands used in the Event Procedure? ... unbound form with a command button to open the report filtered, ...
    (microsoft.public.access.reports)
  • Re: Does DateDiff Have A Bug
    ... a calculated field in a query is the way to go here. ... But here's why I added the DaysRemaining ... I'm trying to write the result of lngDays when it reaches zero days ...
    (microsoft.public.access.formscoding)