sum(iif....)

[Guest]

I just been shown how count iif and sum iff work and have promptly messed it
up. I have a main form with subform that contain contracts. The back table
are one-many clients>>contracts. Each contract can be active or inactive
(-1/0) but this status is stored in a seperate table (LU_contacts).
Tbl_Main has the clientID
Tbl_Contracts has the contract type and contract fee
LU_Contracts has whether the contract is active or not

I wanted a text box that will sum the contract fee's for active contracts
only for the client form that I'm on but don't have a clue what to put in the
control source beyond sum(iif(.....

Any help appreciated..

 

[Guest]

please ignore -- found the answer

 

[Jeff Boyce]

Ian

If you post what you found, others might benefit from what you learned.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/