Trouble summing continuous form in form footer

[cowboy]

As you can see in my jpeg I have a continuous form that calculates a value of rent from a function. I am having trouble figuring out how to add a total of all the rents in the footer. I have tried putting a textbox in the footer and setting the control source to:



=Sum(getRent())
=Sum(txtRent)
=DSum("txtRent","f_Year")
=DSum([txtRent],"f_Year")
=DSum("SumOfqvRent","q_Month_Totals")

and many more, obviously no luck yet, any suggestions?

[SoftwareMatters]

Add the function as a new column in your recordset.
Bring that field on to your form and sum that in the footer like this:
=Sum(FieldName)