Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

--
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.
 
Thank you for the help. Worked very well, and given that as a starting
point, was able to go much further.
 
Back
Top