Summing Multiple Records asigned to one ID

[Richard]

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!

 

[KARL DEWEY]

Sum in the footer.

 

[Richard]

Would you mind elaborating a little more?

Thanks,

Ricardo

 

[KARL DEWEY]

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