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.
= " & [tblRepayment].[DrawIDrpmt
pmt] = " & [tblRepayment].[DrawIDrpmt
the answer should be
but I am getting:
I am greatful for your kindness and time.
thank you. please see attached.