I have a report that contains a subreport. I have passed the value from the subreport to the main report to use in the Report total. My problem is - I can't Sum the field with the Shared/Passed variable.
Formula on Main report to pull the data from the sub to the main:
This resides in the GroupFooter1 section (SO OrderNumber Footer)
I need to total this field, a running total in the report footer to add to the Total Extended Margin.
When I attempt to add a field to Sum the information above into the Report Footer - when the report runs it prompts me for a value.
I'm new to Access 2010.
Any help is greatly appreciated.