If and Dsum control on report problem 1

[FontanaS]

Hello,

I have the following field on the report that works fine -
=IIf(IsNull(DSum("[Amount]","Qry_Information","[ObjectClass] = 'Travel' AND [FiscalYear] = Forms!Frm_Main_Menu.Combo28 AND [Month] < 4")),0,DSum("[Amount]","Qry_Information","[ObjectClass] = 'Travel' AND [FiscalYear] = Forms!Frm_Main_Menu.Combo28 AND [Month] < 4"))

Now i had to add another field called estimated amount (EstAmount). If the Amount field is 0 then use the EstAmount field. If the Amount field > 0 then use that field. How do I incorporate another IIF statement?

I use the Amount field for the first part of the IIF above.

 

[razchip]

Add the first line below, then add your existing statement, plus another ) at the end of the whole statement.

=IIf([Amount]=0,[EstAmount],
IIf(IsNull(DSum("[Amount]","Qry_Information","[ObjectClass] = 'Travel' AND [FiscalYear] = Forms!Frm_Main_Menu.Combo28 AND [Month] < 4")),0,DSum("[Amount]","Qry_Information","[ObjectClass] = 'Travel' AND [FiscalYear] = Forms!Frm_Main_Menu.Combo28 AND [Month] < 4")))



Thanks for the help.
Greg