Error values returned in query...

[noname]

How do I display a "0" instead of it returning "#ERROR" in a query where I
have division.
Also have negative numbers returned on some values, but want "0" displayed
on them also.

[Mark]

Re: Error values returned in query...

I may be wrong, but I don't think you can get #error to display as zero. If
you send the query you are using, I'm sure someone will be able to help

Mark

"noname" <nospam4mepleas e@nospam.net> wrote in message
news:d9_0e.7962 $dP7.3417@fe06. lga...
How do I display a "0" instead of it returning "#ERROR" in a query where I
have division.
Also have negative numbers returned on some values, but want "0" displayed
on them also.

[Madhivanan]

Re: Error values returned in query...


Can you post your query?
Otherwise try this for second part of your queston

Select case when Field<0 then 0 else field end from Table

Madhivanan