fields default value

[dimpie]

I have a table with numeric field data type.
I have trouble assigning a default value.
I want all the fields that the user does not enter to be zero.
So i assigned default value for thst field to zero, but it does not assign.
It is assigning null value.

What do i do??
Thanks

 

[missinglinq via AccessMonster.com]

I'm not really sure what your ptoblem is; when you create a numerical field
in an Access table, the default value is automatically set to Zero! You
shouldn't have to do anything else! What is it doing that makes you think
it's assigning a Null value? Have you done any testing to confirm this, and
if so, have you tested more than one of your numerical fields?

 

[dimpie]

when i do some calculations for reporting for those fields, the calculations
are not being performed. So when i check the values in these fields they are
all empty even though they are all numeric fields.

So when i maually enter zeros, then the caluclations work fine.

Please advice
Thanks

 

[missinglinq via AccessMonster.com]

When you say "So i assigned default value for thst field to zero, but it does
not assign" what exactly do you mean? And where are you trying to assign the
default value, in the form or in the table definitions?

 

[dimpie]

I assigned in the design view of the table.

 

[Corey-g via AccessMonster.com]

Did you do this during the table creation, or after? If after, it would only
apply to new reocrds added after you added in the default value. A simple
update query should fix this for you though...

Update tablename set field = 0 where field = null;

HTHs,

Corey