Help with defaults in forms

[hbrady99]

I need some help backpopulating fields in a form to a default value of zero. I understand that these are not showing the default value because the fields were added after these records, I just need to know how to make all of these fields say zero, hopefully in the easiest way (i.e., not going back and typing "0" in every field).

Thanks!

 

[gol4]

Several ways but the best would be an update query

update tablename set fieldname = 0 where isnull(fieldname)