Iff

[BorisGomel]

Hello ,
I need set two iif from union query in report >
I have done this :
=IIf(Client=”1”,(Sum(IIf([Code]="001" Or [Code]="008" Or [Code]="011" Or [Code]="021",[GrossAmount],0),0))


=IIf(Client=”2”,(Sum(IIf([Code]="001" Or [Code]="008" Or [Code]="011" Or [Code]="021",[GrossAmount],0),0))
I nedd to sum Gross Amount based on client thta can be 1 or 2 in the same report .
It doesn't work .
Thank you foir advise.
Boris

[ssanfu]

=IIf(Client=”1”,.......

Is the field type of "Client" TEXT or a NUMBER?

"1" is text

1 is a number

"1" <> 1

You could try:

=IIf(Client= 1,(Sum(IIf([ Code ]= "001" Or [ Code ]= "008" Or [ Code ]= "011" Or [ Code ]= "021",[GrossAmount],0),0))
=IIf(Client= 2,(Sum(IIf([ Code ]= "001" Or [ Code ]= "008" Or [ Code ]= "011" Or [ Code ]= "021",[GrossAmount],0),0))