Subreport totals

[SVNTY7]

Hello,
I have searched previous postings, and can't seem to find the solution to my particular problem.

I have a report sorted first by year then by soc. sec #. I have a subreport that lists the various loans made to a person over the course of a year (each person can have numerous loans). In the subreport footer I am able to total the amount of the loans for a particular person without any problem. What I would like to do is total the amount of the loans issued to all people for the entire year in the main report footer. I have a textbox with the following code, but it only totals the last SS# entered.

=[qryloansubreport].[Report]![GrandTotal]

Can anyone assist?

Thanks,

 

[Brian900]

In the report footer in and unbound textbox type the following:

=Sum([TotalLoans])

 

[SVNTY7]

This solution did not work, I ended up with an error asking for the Parameter value [TotalLoans]

Any other suggestions?