Null Conversion

[destinman_2000]

I have a table that is basically a duplicate of my printed Aged Rec schedule.
Values are updated to this table through queries that change data depending
on the date used. The problem I am having is that there are periods where a
field in the aging table is null. How can I get a default " 0.00" to be
entered into the field instead of the null value. Of course, this null value
screws up any future calculations based on this table. I have tried to set
the default value to "0.00" in the table design but this does not seem to
work.

Thanks for you help !!

 

[John W. Vinson]

I have a table that is basically a duplicate of my printed Aged Rec schedule.
Values are updated to this table through queries that change data depending
on the date used. The problem I am having is that there are periods where a
field in the aging table is null. How can I get a default " 0.00" to be
entered into the field instead of the null value. Of course, this null value
screws up any future calculations based on this table. I have tried to set
the default value to "0.00" in the table design but this does not seem to
work.

Thanks for you help !!

Answered in microsoft.public.access. Please don't "multipost" - if you must
post in more than one newsgroup (it's rarely necessary) then crosspost
instead, so volunteers won't need to waste time answering a question which has
already been answered elsewhere.