Syntax error

[scoe]

Hi
I'm sure I'm missing something very silly here, I have the following IIf statement that works perfectly when put into a query but brings up the Syntax error "Syntax error(comma) in query expression", when I put it in a test box in a report.



The statement is:
[IIf([Column]="CP16",([SumOfTotal]))]

I would appreciate any pointers as to why this is not working.

Thank you.

[RuralGuy]

The IIF function requires both an If-True and an If-False argument.
IIF([Test],If True,If False)

[scoe]

Hi

I have tried that and still no joy, I have tried:
[IIf([Column]="CP16",[SumOfTotal],""] and [IIf([Column]="CP16",[SumOfTotal],"0"]
and as I mentioned, the previous works pefectly in a query but not in the text box.

[scoe]

Found the problem, the report had developed a bug lol....Opened a new form and the statement works fine, thank you for your help.

[RuralGuy]

Thanks for posting back with your success and solution.