Calculated Textbox with Where statement

[sud2017]

Hi Experts,



In the below calculated textbox formula in subform, I want to include some WHERE statement for a selected OppIF_FK (field in subform). In this case, for example, i want to calculate sum WHERE OppID_FK = 6. I am not too sure if it needs modifying the below formula or VBA code etc.?

Your help will be greatly appreciated.

=Sum(IIf([Currency]="USD",[OppDet_UnitCost]*[OppDet_Qty],0))+Sum(IIf([Currency]="CAD",[OppDet_UnitCost]*[OppDet_Qty],0))/[Parent].[Exchange]

Thank you.

[June7]

Perhaps just need to add criteria to the IIf()

[Currency]="USD" AND [OppID_FK]=6

[Currency]="CAD" AND [OppID_FK]=6

[sud2017]

That worked great June7. Thank you very much!