Total row in report from query

[brandi.m99]

Hi All!

I have a query that is pulling all the the transactions entered in a table with a parameter of the date the payment transaction was entered. With that I am wanting a report that will include a total of all the payments for that day. Do I need to adjust my query or is this something I can modify in my report?

 

[llkhoutx]

You can total in any footer (page, report) in your report. Try in a bound control record source use =Sum([YourPaymentcontrolName]). Note include the brackets.

 

[brandi.m99]

I have tried this and get an error when I put the report in to report view.

 

[llkhoutx]

You're reference is probably bad.

 

[brandi.m99]

=Sum([PaymentAmount])
this is reference my PaymentAmount Field that is what I am trying to sum at the end of the report...How do i fix?

 

[brandi.m99]

I found the issue in the sum needed to be in the report footer and not the page footer to work correctly!