I've got a report "rptSummary" that shows drug names + number of uses and the sum of there cost over a fixed period. This is all calculated through a query "qrySummary".
The report "rptSummary" has a calculated field to give the total of all the drug costs over that time period "TotalSumOfCost".
I want to use this value "TotalSumOfCost" in the Criteria for another query "qrySummary1". This is the control source for another report "rptSummary1" which is a sub report in "rptSummary"
If it was a form the criteria would work as:
<[Forms]![frmSummary].TotalSumOfCost
Unfortunatly for reports a similar formula doesn't work:
<[Reports]![rptSummary].TotalSumOfCost
When running the report it asks for the value
[Reports]![rptSummary].TotalSumOfCost & rptSummary
After many hours/days searching I am unable to find a solution and I'm hoping somebody with the right sized brains can point me in the right direction.
Thank you in advance
The report "rptSummary" has a calculated field to give the total of all the drug costs over that time period "TotalSumOfCost".
I want to use this value "TotalSumOfCost" in the Criteria for another query "qrySummary1". This is the control source for another report "rptSummary1" which is a sub report in "rptSummary"
If it was a form the criteria would work as:
<[Forms]![frmSummary].TotalSumOfCost
Unfortunatly for reports a similar formula doesn't work:
<[Reports]![rptSummary].TotalSumOfCost
When running the report it asks for the value
[Reports]![rptSummary].TotalSumOfCost & rptSummary
After many hours/days searching I am unable to find a solution and I'm hoping somebody with the right sized brains can point me in the right direction.
Thank you in advance