Re: How to display total by category at the end of the report?
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Sat, 06 May 2006 23:02:39 -0500
Maulik Bhatt <Maulik Bhatt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am preparing database of the money collected from clients. The money can
be in cash or by cheque. In the monthly report, I want to display the total
amount collected in cash and by cheque. I tried to place it in the report
footer, but it showed error. How can display the cash total and cheque total
at the end of the report?
If anyone requires, I can send the database; which is in Access 2003 version.
You didn't say how you distinguish one kind of payment from
another or how the amount is stored so I'll just guess that
there is an Amount field in the report's record source
table/query (*not* a control on the report) and that there
is a Cash field that is True for cash and False for checks.
Based on the above assumptions, use text boxes in the report
footer with expressions like:
=Sum(IIf(Cash, Amount, 0))
and
=Sum(IIf(Not Cash, Amount, 0))
--
Marsh
MVP [MS Access]
.
- Prev by Date: Re: Help me count records without duplicates
- Next by Date: Re: TOC in Access
- Previous by thread: Re: Help me count records without duplicates
- Next by thread: Problem with Report Grand Total
- Index(es):
Relevant Pages
|
