D
DocBrown
In the Group header I have a subreport where the Source Object is a parameter
query whose criteria is based on a field in the Group Header. The report is
grouped on the [ProgramArea] field.
The criteria is:
[Reports]![Programs Activities Cumulative]![ProgramArea_Box]
In the Report Footer I want to generate a subreport where ALL the data is
summed for all groups. I need to use a sub report because the data is from a
related table with a one to many relationship to the primary table.
How do I set the criteria, or use another method to have the Report Footer
subreport generate a cumulative for ALL the related table data. I'm hoping to
use the SAME query but add an OR or AND critieria.
query whose criteria is based on a field in the Group Header. The report is
grouped on the [ProgramArea] field.
The criteria is:
[Reports]![Programs Activities Cumulative]![ProgramArea_Box]
In the Report Footer I want to generate a subreport where ALL the data is
summed for all groups. I need to use a sub report because the data is from a
related table with a one to many relationship to the primary table.
How do I set the criteria, or use another method to have the Report Footer
subreport generate a cumulative for ALL the related table data. I'm hoping to
use the SAME query but add an OR or AND critieria.