Re: Calculation question

2002-12-01 Thread Bhavin Vyas
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

Calculation question

2002-12-01 Thread Chris Kay
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