Need some help with default values

Compredneck

New member
Local time
Yesterday, 18:20
Joined
Dec 14, 2005
Messages
7
Hello,

I created a db for my property owners association. I have created a formula that adds up each year, but it won't let me do that unless I put in 0.00 for the blank fields. I was wondering if anybody could let me know if there is anyway that I can have 0.00 placed in the field so that my formula will work.

Thanks-
Compredneck
 
Compredneck said:
Hello,

I created a db for my property owners association. I have created a formula that adds up each year, but it won't let me do that unless I put in 0.00 for the blank fields. I was wondering if anybody could let me know if there is anyway that I can have 0.00 placed in the field so that my formula will work.

Thanks-
Compredneck

Go to the properties for that field in your table and set the default value you want.
 
hmm ?

I don't think that would work after the fact ( after entering the data ) ... default values are only applied to new records.

I would suggest to run code to update all Null values to 0 before summing the info in the fields. You cannot calculate null fields.

QT = )
 
QTNM said:
I don't think that would work after the fact ( after entering the data ) ... default values are only applied to new records.

I would suggest to run code to update all Null values to 0 before summing the info in the fields. You cannot calculate null fields.

QT = )


Ok, leave the default value for the new records, but run code to update the old records.
 
Thanks

selenau837 said:
Ok, leave the default value for the new records, but run code to update the old records.

Thanks Selenau837.

Compredneck
 
Thanks

QTNM said:
I don't think that would work after the fact ( after entering the data ) ... default values are only applied to new records.

I would suggest to run code to update all Null values to 0 before summing the info in the fields. You cannot calculate null fields.

QT = )


Thank QTNM
 

Users who are viewing this thread

Back
Top Bottom