Syntax Error in SUMIIF Query

**RAJESHKUMAR R** · 02-13-2022, 05:18 AM

Dear Friends,

I am trying to create below SUM IIF in one of the Query, when I am trying to run the query... It is popping up as "Syntax Error"...

Code:

Expr1: Sum(IIf([Database]![cable_type]=[Database]![cable_type],[Database]![Net Inventory],0))

Could you please help me to understand what am I doing wrong here?

Thanks & Regards,
Rajeshkumar R

**Welshgasman** · 02-13-2022, 05:34 AM

Are you sure it is that?, as this works fine for me?

Code:

SELECT Transactions.Description, Sum(IIf([description]=[description],1,0)) AS Expr1
FROM Transactions
GROUP BY Transactions.Description;

However, how could cable_type ever be different?

**Bob Fitz** · 02-13-2022, 05:35 AM

I think you need to have your criteria in the criteria row.

**Micron** · 02-13-2022, 09:08 AM

Your thread title says 'syntax error in query' so why are you just showing the expression? Show the entire query sql and maybe we'll see the problem.