Hello All,

I created a order form and attached a sub form for products as shown below.
Also each form has its own table.

Main order form\ Order table:
• Customer name
• Order ID (Autonumber/Primary ID)
• Order date
• Ship date

Attached Products Subform\ Products table
• Commodity
• Size
• Style
• Variety
• Quantity
• Cost
• COM_ID (Autonumber/Primary ID)

I then created a report that prints this information out in our invoice
format. On this report I need to sum the quantity and price of products
ordered on a given order. How do I total the quantity and cost for each
order when I have multiple records(Products) for each order?

Thanks for your help!

Sum in the footer.
--
KARL DEWEY
Build a little - Test a little


"Richard" wrote:

> Hello All,
>
> I created a order form and attached a sub form for products as shown below.
> Also each form has its own table.
>
> Main order form\ Order table:
> • Customer name
> • Order ID (Autonumber/Primary ID)
> • Order date
> • Ship date
>
> Attached Products Subform\ Products table
> • Commodity
> • Size
> • Style
> • Variety
> • Quantity
> • Cost
> • COM_ID (Autonumber/Primary ID)
>
> I then created a report that prints this information out in our invoice
> format. On this report I need to sum the quantity and price of products
> ordered on a given order. How do I total the quantity and cost for each
> order when I have multiple records(Products) for each order?
>
> Thanks for your help!
>

Would you mind elaborating a little more?

Thanks,

Ricardo

"KARL DEWEY" wrote:

> Sum in the footer.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Richard" wrote:
>
> > Hello All,
> >
> > I created a order form and attached a sub form for products as shown below.
> > Also each form has its own table.
> >
> > Main order form\ Order table:
> > • Customer name
> > • Order ID (Autonumber/Primary ID)
> > • Order date
> > • Ship date
> >
> > Attached Products Subform\ Products table
> > • Commodity
> > • Size
> > • Style
> > • Variety
> > • Quantity
> > • Cost
> > • COM_ID (Autonumber/Primary ID)
> >
> > I then created a report that prints this information out in our invoice
> > format. On this report I need to sum the quantity and price of products
> > ordered on a given order. How do I total the quantity and cost for each
> > order when I have multiple records(Products) for each order?
> >
> > Thanks for your help!
> >

Have a footer in your report at the level you want to sum to and insert
unbound text box with source =Sum([YourFieldToSum])

--
KARL DEWEY
Build a little - Test a little


"Richard" wrote:

> Would you mind elaborating a little more?
>
> Thanks,
>
> Ricardo
>
> "KARL DEWEY" wrote:
>
> > Sum in the footer.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "Richard" wrote:
> >
> > > Hello All,
> > >
> > > I created a order form and attached a sub form for products as shown below.
> > > Also each form has its own table.
> > >
> > > Main order form\ Order table:
> > > • Customer name
> > > • Order ID (Autonumber/Primary ID)
> > > • Order date
> > > • Ship date
> > >
> > > Attached Products Subform\ Products table
> > > • Commodity
> > > • Size
> > > • Style
> > > • Variety
> > > • Quantity
> > > • Cost
> > > • COM_ID (Autonumber/Primary ID)
> > >
> > > I then created a report that prints this information out in our invoice
> > > format. On this report I need to sum the quantity and price of products
> > > ordered on a given order. How do I total the quantity and cost for each
> > > order when I have multiple records(Products) for each order?
> > >
> > > Thanks for your help!
> > >