Adding Totals in Report

[perrydaniel]

Hi, fairly new to reports in Access and was hoping someone could give me a hand getting some totals in a report.

I have four columns:-
Month
Full Amount
Amount Taken
Amount Remaining (Unbound Text Box) which is Full amount - Amount Taken

I have these grouped by month, my problem is getting another box which shows the sum of the total remaining at each month end.

Would appreciate any help that can be offered.

Thanks

Perry

 

[dhookom]

Do we know how much you started with at the beginning of the month?

=Sum([Full Amount]) - Sum([Amount Taken])

If this doesn't answer your question, come back with some sample records and expected display in the report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[perrydaniel]

Month
Jan
Account Full Amount Amount Taken Amount Left
1 5000
1000
2000
2000

2 7000 0 7000

Total Left 9000

This is how i would like it too look.

Thanks

 

[dhookom]

You provided the expected display but forgot to provide some sample records.

It would help if you provided the actual records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[perrydaniel]

Sorry,

Example 1 January 06
Account No Customer Full Leftto
Amount Trans take
123456 Mr Smith 50000
30000
10000

Total 40000
10000

654321 Mr Brown 70000
10000

Total 10000
60000
Total 70000

The figure of 70000 is the one i cant get to work, the left to take column is a calculated field in my report.

Thanks, hope this makes it clearer

 

[dhookom]

You did not understand my request which I had bolded in my previous reply:

[red]some sample records[/red]

. All you did was show your expected final display. I was hoping that you would provide a view of the raw records that you might see if you viewed the datasheet of your reports record source. I would only need to see the records and fields used to generate your final display.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[perrydaniel]

Sorry,

These are two actual records from customer table
AccountNo 123456
Name John Smith
LAmount 100000

AccountNo 987654
Name Peter John
Lamount 75000

These are related records from the transaction table
AccountNo 123456
DrawndownAmt 30000
DrawdownDate 12/5

AccountNo 123456
DrawndownAmt 8000
DrawdownDate 18/5

AccountNo 987654
DrawndownAmt 75000
DrawdownDate 12/5

I hope this helps, thanks for your patients