Totally Subreports on Main Report Detail

littlepeaches68

New member
Local time
Today, 06:34
Joined
Feb 13, 2006
Messages
5
I have a report with numerous subreports. I need to total a field from two of my subreports on the main report detail. The catch of it is the field is summing a field in the sub report. Here is my current code which does not work but may give you an idea of what I am trying do.

=[Reports]![Product Code Specification]![Meat Standards Sub].Report.BatchTotal+[Reports]![Product Code Specification]![Ing Standards Sub].Report.BatchTotal

I would appreciate any help!
 
Try this

=[Meat Standards Sub].Report!BatchTotal+[Ing Standards Sub].Report!BatchTotal
 
I ended up with a parameter message box.
 
hi

one thing i have done is make my sub form into a query with the query doing the calculation for me - i then made a form with the query. You should be able to add the 2 sub forms together ok this way
 

Users who are viewing this thread

Back
Top Bottom