Subtotals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PA - 26 Jul 2006 13:32 GMT

I have a DB where I enter orders, OrdNumber, CustNumber, InvoiceAmt, and
various other fields.
To simplify my question,
If I have three customers: A, B, and C and have several orders for each in
varying amounts, I need to add the order amounts (InvoiceAmt) for each of the
three customers, in much the same manner that the Subtotal feature in Excel
would accomplish for me, and put them into a report. I then would need a
grand total.
Can anyone give me some guidance on how to get started.
Thanks for any assistance.
Paul

Reply to this Message

Al Camp - 26 Jul 2006 13:46 GMT

PA,
You'll need to add a Grouping to your report based on Customer (ex. CustID).
(use the report Sorting and Grouping dialog box)
In that Sorting and Grouping dialog, create a Customer Header and Footer, and
place the CustID and the CustName field in that Header.
In the Detail section of the report place all your Invoice data. (ex. InvNo and InvAmt)
In the CUSTOMER footer, an unbound text control with = Sum(InvAmt) would yield the
totals for each customer.
In the REPORT footer = Sum(InvAmt) would yield the totals for ALL customers.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.

>I have a DB where I enter orders, OrdNumber, CustNumber, InvoiceAmt, and
> various other fields.
[quoted text clipped - 7 lines]
> Thanks for any assistance.
> Paul

Reply to this Message

PA - 29 Jul 2006 18:03 GMT

Thank you for the help. Worked very well, and given that as a starting
point, was able to go much further.

> PA,
> You'll need to add a Grouping to your report based on Customer (ex. CustID).
[quoted text clipped - 17 lines]
> > Thanks for any assistance.
> > Paul

Reply to this Message