I
Ian
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..
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..