Hi
I am getting the following error. I am using SQL Server DB.
My query looks like :
SELECT Register.Register, Register.SR_Num, Register.CSC_Project_Code, Register.Project_Common_Name, Sum(IIf(IsNull([StakeHolders].[StakeHolders]),0,IIf([StakeHolders].[Status],1,0))) AS StakeholderCount FROM (Register INNER JOIN SR_Status ON Register.SR_Status = SR_Status.SR_Status) LEFT JOIN StakeHolders ON Register.Register = StakeHolders.Register WHERE (((SR_Status.Status)='Active')) GROUP BY Register.Register, Register.SR_Num, Register.CSC_Project_Code, Register.Project_Common_Name ORDER BY Sum(IIf(IsNull([StakeHolders].[StakeHolders]),0,IIf([StakeHolders].[Status],1,0)))

Can anyone explain where the actual problem is? Can we use IIF in SQL Server, the queries are designed earlier before I joined this project.

Regards everyone

sinapra

__________________
sinapra

Hey,

No IIF support, but you can use ISNULL. I'm not sure of some of the purposes of your IIF statements; you may be able to use a SQL Server case statement instead.

, case
    when <condition> then
    when <condition> then
    else
end,

Brian