Total Expenses By Group!

[Kaspro]

Hi all, i'm creating a report to show the expenses grouped by Expenses Type,
what i need is to show the total expenses of each Type, iam using 2 tables,
expenses which holds the expenses details and expenses types which defins the
type or category of each expenses!!
Thank you all!

 

[Marshall Barton]

Hi all, i'm creating a report to show the expenses grouped by Expenses Type,
what i need is to show the total expenses of each Type, iam using 2 tables,
expenses which holds the expenses details and expenses types which defins the
type or category of each expenses!!

If you are grouping by the type, then use a text box in the
group footer (or header) with an expression like:
=Sum(amount)

 

[Kaspro via AccessMonster.com]

I tried that, but when i use Sum(Total) it gives me the total of the whole
table not by group!

 

[Marshall Barton]

I tried that, but when i use Sum(Total) it gives me the total of the whole
table not by group!

Then you need to put the text box in your **group** footer,
not the report footer. If you don't have a group footer,
create a group on your Type field in the Sorting and
Grouping window (View menu).

 

[Kaspro via AccessMonster.com]

Thank you alot man, it works pretty fine!