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.
Nice!
that works. I will need to ask a follow up because I need another condition of tblRepayment.PaymentMadeYN="Yes". I am fiddling with it and cant figure it out. thank you for your expert assistance and the tips about dsum and nz. I am not a coder as you probably figured out.
=Sum(DSum("[Amount]","tblD
+Sum(DSum("[Amount]","tblR
I don't know where you want this on the form so I didn't try it.
You can set the format of the control to standard rather than embedding the Format() function in the expression.