I want to update a null field with $0.00

[mikecal]

I have a table with 3 fields containing currency values. When the table data are imported, any fields with no amount specified are null. I would like to add a zero value to all of the null fields. What is the best and easiest way (I am a real novice at this) to accomplish this. Thanks for your help.

 

[sambo]

Set the data type to Currency in Table Design view. This automatically sets null Dollar amts to $0.00 (or whatever format you specify)