Zero fill

[rbtrout]

I've been stuck with the task of learning Access and all the joys therein. I programmed back in the old FoxPro days and am familiar with SQL, but I could use some newbie help.



I've got a database with about 15 fields and 30000+ records. Various queries brought in the data. Some of the fields that are numeric have nothing in them. I need to know how to fill all blank numeric fields with a zero.

Thanks.

[pbaldy]

An update query would be one way:

UPDATE TableName
SET FieldName = 0
WHERE FieldName Is Null

[rbtrout]

So simple that I missed it. Thanks for the info, problem solved.
RB

[rbtrout]

That works, 1 column at a time. How about all the columns in the table that are null?

[pbaldy]

Try

UPDATE TableName
SET FieldName1 = Nz(FieldName1, 0), FieldName2 = Nz(FieldName2, 0), ...

[rbtrout]

Again, that worked. Thanks for the help. I forgot that I can do SQL commands, that will help me a lot.

[pbaldy]

No problemo, and welcome to the site by the way!