Reports

[Karen]

Report requires: Bank Total Income

First I would like to say that several years ago when I was setting up my database, I received invaluable help from the Forum. Thank you for this wonderful tool.

I have multiple forms of revenue for two banks that I need to receive an Total Income for Bank "A" and Bank "B" within the same report. I feel that if someone could help me calculate the Total for Bank “A,” I would be able to do the same for Bank “B."
For bank “A,” I have:
1. Store Sales: ASalesDep: [SS] + Nz([More],0) - Nz([Less]) (This expression is within the Query)
2. Cash Contributions: [ACDDep]
3. Other Income: [AOIDep]
4. Other Sales: [AOSDep]
The structure of the report is this:
Bank Header
IncType Header
Detail
IncType Footer
Bank Footer
Within Detail, I have the various information I need including the types of income as listed above.
Within the IncType Footer, all totals are calculated correctly. I have:
=sum([ASalesDep]);=sum([ACDDep]); =sum([AOIDep]); =sum([AOSDep])
The problem arises when I try to calculate the combined forms of income for a Total Bank Income.
I’ve tried multiple, formulas and expressions and not one of them works.
S O S Please, Please,I need H E L P
God bless,
Karen

P. S. Help Please, Please Help. I have worked on this so many times over the years that I find it easier to total the income types, go into the design of the report and use a Text Box for the total.

[June7]

You have a field for each type of deposit?

Why don't you just add the four textboxes?

What does 'not work' mean - error message, wrong result, nothing happens?