M
mabi
When inserting a calculation into a query, how would you
format the result to a default number (0) if the result
would be an error?
Example:
SELECT
.a,
.b, (
.a)/(
.b) AS c
ORDER BY (
.a)/(
.b) DESC
If a and b both contained 0, the result of (
.a)/
(
.b) would be "#ERROR" ... how can I get the field
to display "0"?
Thanks in advance for the help ....
format the result to a default number (0) if the result
would be an error?
Example:
SELECT
ORDER BY (
If a and b both contained 0, the result of (
(
to display "0"?
Thanks in advance for the help ....