Global Find and Replace null values

[pat_nospam]

Weird question - I have a table full of empty fields I need to replace with the default $0.00. The Find and Replace doesn't seem to want to work because I can't enter "Null" as an option, or it will put the word "Null" in.

Any ideas? Thanks so much

Pat

 

[pat_nospam]

Nevermind - Used and update SQL query.

 

[pat_nospam]

Yup - I needed the zeros. The paradox database we had converted from inserted nulls to equal 0. In our beautiful access application, a line of amounts end up with a sum, but need the $0.00 in order to work (if it sees a NULL field, it doesn't add).

Thanks for the precaution though, you guys are always looking out for me!