Experts,
Im tring to sum the amount in the form in the attached db. I am way off and have spent too much time trying to see where I am wrong so I am turning it over to the experts. I have pared down the db to only what is needed and the form appears auto. Please double click the amount in the form that appears on auto and then another form appears that shows the amount calculated with the formula below. I am just trying to sum these amounts. I imagine an expert has a different way of doing this. I am not sure if dsum is the correct method.
=Sum(Format(Nz(DSum("[Amou
nt]","tblD
raws_Detai
ls1","[ID]
= " & [tblRepayment].[DrawIDrpmt
]),0),"Sta
ndard"))+
+Sum((Format(Nz(DSum("[Amo
unt]","tbl
Repayment"
,"[DrawIDr
pmt] = " & [tblRepayment].[DrawIDrpmt
]),0),"Sta
ndard")))
the answer should be
-6,796,284.00 (282,000,000.00-282,000,00
0.00-6,010
,597.00-78
5,687.25)
but I am getting:
-20,388,852.75
I am greatful for your kindness and time.
thank you. please see attached.
EE.accdb
EE.accdb