Total amount at end of report

[Brian62]

I am trying to total the amount owed from customers on a report. I have amount in the Table and Query where I would enter the amount in a form. I am filtering the report by month due but want the total at the end of the report to show total outstnding. I tried =Sum[(Amount)] in Control source in the report of the Unbound Total text box but I can't get it to work.

 

[stopher]

Looks like your brackets are in the wrong order.
Try:
=Sum([Amount])

Are you wanting a total of all records regardless of the filter?
Chris

 

[Brian62]

Actually the script is written correctly just wrote it down wrong here. I want the total of all records in the report that is filtered by the query.
I have the query filtered by month to show late payments:

Between date()-30 and date()-59

I know this doesn't matter for what I am asking but just to give you an idea what I am trying to do. bri

 

[stopher]

I kind of figured my first suggestion was just too easy.

When you say you can't get it to work, what do you mean exactly? Are you getting an error?

I assume [amount] is a field in your underlying data source ? What you can't do is sum using the name of an object i.e. you can't sum using the name of the text box (it has to the the source field name)

Chris

 

[Brian62]

Yes, the text field says error.

The amount is the field name in the Table/Query.

If I can't use the field name (amount) then how do I add the total sum of amount?

Do I need to create another footer so the total shows on the last page?

 

[stopher]

Where have you placed this text box? It won't work in the detail section. If you want it at the end of the report then make sure the report footer has been added to the report and place it there.
Chris

 

[Brian62]

I knew it was something easy,p[lacement is everything. That was it!! Thanks!!!