Report Total from Subreport

  • Thread starter Thread starter Del
  • Start date Start date
D

Del

Hello,

Thank you in advance for any suggestions...

I have a database that is used to track customer orders for a small company.
The database has a report that shows All Open Orders.
This report has a subreport that shows detail for each part ordered. The
Subreport shows the following items Part ID, Order Qty, Sell Price,
Extended Price (Order Qty x Sell Price). The subreport is capable / limited
of 12 individual parts data. The subreport is linked to the main report by
Order Number. In the Order Number footer is an unbound text box that shows
the total extended price for all parts on a specific order.
Example:
(The Subreport is called rptOrderDetailSubrpt)
Order Number 1
Part ID Order Qty Sell Price Extended Price
123456 1 $100.00 $100.00
654321 2 $150.00 $300.00
Order Total $400.00

Order Number 2
123456 2 $100.00 $200.00
654321 1 $150.00 $150.00
789011 1 $ 50.00 $ 50.00
Order Total $400.00

This all works fine. The problem I am having is creating a report total. The
user wants to be able to run this report and not only see the total value of
each individual order but also the total value of all orders on listed on the
report. I have tried =sum([rptOrderDetailSubrpt]![OrderTotal]) but when the
report is run the I receive a dialog box that says Enter Parameter Value
rptOrderDetailSubrpt!OrderTotal

I am using MS Access 2000 and 2002....

Thank you,
Del
(e-mail address removed)
 
The easiest method may be to create a totals query that totals the extended
price by Order. Add this totals query to the record source of the main
report. Join the Order Number fields and include the TotalExtendedPrice in
the main report's query.
 
Back
Top