Calculated Fields

[mtbound]

I am trying to set the default value in several currency fields to $0.00 so they can be calculated in a calculated field. Currently if the fields do not have a value in them, then the calcualted field does not calculate.

I have tried to set each field value to 0, =0, and even "$0.00" but none of the methods work. I would rather find a way to set the default value to $0.00 rather than manually typing in 0.00 in each field.

Help!!:banghead:

 

[boblarson]

defaults only work for new records. Existing records would need to have an update query run to set the field to 0 if null.

If you aren't using a web database, I suggest NOT using calculated fields but do it in a query. That is a "best practice" as an FYI.