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)

 

[Pat Hartman]

You can modify the table so that the default value for the field is 0 rather than null. To fix the existing records, you'll need to run three update queries. One for each field. Set the selection criteria to null and the update to cell to 0.