Null values - Zero length strings

[Ted]

I am writing a query for a linked table. I want to total
all the values in a particular field - check amount. The
problem is that some of these fields are blank. Whne we
print an alignment check, this is written to the file as a
blank amount. I have to have these in the table/query in
order to display a complete listing of all check numbers
used. How can I write an expression that converts only the
blank records (alignment check amounts to .00? If I leave
them as they are, I get an error on the claculation.

Thanks....

 

[Jeff Boyce]

Ted

Take a look at the Nz() function ... something like:

Nz([YourAmountFieldName],0)

should convert null values to 0's. If you have a zero-length string (""),
the Nz() function won't catch it!

Good luck

Jeff Boyce
<Access MVP>

 

[Guest]

Thanks for the response. They are zero-lenght strings and
not null values, so the Nz doesn't catch them...as you
predicted.