Fields with null values

J

Jörg Baas

Hi NG!
My sofwtare creats a database in the dbf (dBase) format. I link this table
into Access for further working.
The database contains a lot of numeric fields. When browsing the data in
Access, in fields in which nothing was written, the value is blank. I would
like to have zero in it. How can I do that.
My knowledge in Access is very basicly.
Thanks for any help!

Jörg
 
J

John Vinson

Create an update query. In the 'criteria' row of the numeric fields in the
query put Is Null
and in the 'Update to' Row put 0
Click to expand...

WHOA Dennis! That's dangerous.

If the OP does this on multiple fields, then it will replace ALL those
fields with 0 if *any one* of them is NULL.

Jörg, if you want to run this update query, update each field (let's
say it's named FieldA) to

NZ([FieldA])

instead of to 0.


John W. Vinson[MVP]
 
Top