> 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.
>
>
> "PA" <PA[ at ]discussions.microsoft.com> wrote in message
> news:61C76F2A-C00E-4385-B1B9-68A475027DA6[ at ]microsoft.com...
> >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
>
>
>