Hi all

please suggest a solution

Database is Access
Is it possible to use IF in SQL statements like in stored proc ?

eg.

SELECT SUM(TABLE.SOMETHING) / SUM(TABLE.SOMETHING_ELSE) AS RESULT

Now if the second sum is 0 generates error

I want to give to RESULT a specific value in that case

Thank you for your time

Best regards

Nikos Pappas

IIF()

SELECT
    IIF
    (
        SUM(TABLE.SOMETHING_ELSE) = 0, 
        mySpecificResult,
        SUM(TABLE.SOMETHING) / SUM(TABLE.SOMETHING_ELSE)
    ) AS Result

Look in Access online help for more information.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Nikos" <pappas@c...>
Subject: [asp_databases] if in SQL statement


: Hi all
: 
: please suggest a solution
: 
: Database is Access
: Is it possible to use IF in SQL statements like in stored proc ?
: 
: eg.
: 
: SELECT SUM(TABLE.SOMETHING) / SUM(TABLE.SOMETHING_ELSE) AS RESULT
: 
: Now if the second sum is 0 generates error
: 
: I want to give to RESULT a specific value in that case
: 
: Thank you for your time

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Cheers Ken
Thank you
Regards
Nikos
At 06:51 =F0=EC 14/11/2002, you wrote:
>IIF()
>
>SELECT
>     IIF
>     (
>         SUM(TABLE.SOMETHING_ELSE) =3D 0,
>         mySpecificResult,
>         SUM(TABLE.SOMETHING) / SUM(TABLE.SOMETHING_ELSE)
>     ) AS Result
>
>Look in Access online help for more information.
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Nikos" <pappas@c...>
>Subject: [asp_databases] if in SQL statement
>
>
>: Hi all
>:
>: please suggest a solution
>:
>: Database is Access
>: Is it possible to use IF in SQL statements like in stored proc ?
>:
>: eg.
>:
>: SELECT SUM(TABLE.SOMETHING) / SUM(TABLE.SOMETHING_ELSE) AS RESULT
>:
>: Now if the second sum is 0 generates error
>:
>: I want to give to RESULT a specific value in that case
>:
>: Thank you for your time
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>