Dsum and Calculated Field / Parent & Sub
Posted on 2016-09-20
I seem to get a #error in the below Dsum.
[USD Equiv] is a calculated field in a table and I guess this is why I get the error as the formula works fine when I switch [USD Equiv] to [Amount] (Amount is not a calculated field in the same table)
here is the formula that returns #error (this is in a text box in the Parent form):
=Nz(DSum("USD Equiv","tblDraws_Details1","DrawID1=" & [ID]),0)
here is the calculated field [USD Equiv] in the subform:
USD Equiv: IIf([CurrencyID]=1,[Amount],[Amount]*[ExchangeRate])
How can I sum [USD Equiv].[tblDraws_Details1] (The Subform) and show this sum in the Parent?