Defaultvalue - ms access 2007

[odrap]

In a table tblArticles there are the following fields:
Sellprice (numeric - currency)
buyprice (numeric - currency)
Stock (numeric - double)


Is it wise to set the default value of this fields to 0, to eliminate a null value or a empty value in these fields ?

 

[Mike375]

It depends

Is 0 to be the value or does 0 mean a value was not available?

Think about filling in a form. We could have 0, N/A (not applicable) or it could be blank.

If you were filling out a form for somone on assets, liabilities and income and you did not obtain a figure for rental returns, would you enter a 0. If you did then that would be read as their rental value being 0. N/A could mean they do not have any rental property and a blank means you forgot to get the information. Of course N/A is a problem in a number form.