I am guessing a default value of NULL should do it.
Bhavin.
- Original Message -
From: "Chris Kay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 01, 2002 4:54 PM
Subject: Calculation question
I have a few fields in a table that I need to calcu
I have a few fields in a table that I need to calculate, yesterday I
find out that they don't want it to display as 0.00 if nothing was
entered into the database.
I currently have the fields set to decimal(10,2)
Would any1 suggest a better way to do this to not display the 0.00 if
nothing was en