Report Subtotal linked to query criteria for subreport? (1 Viewer)

Thicko

Registered User.
Local time
Today, 08:38
Joined
Oct 21, 2011
Messages
61
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
 

Thicko

Registered User.
Local time
Today, 08:38
Joined
Oct 21, 2011
Messages
61
That's fixed it, Thank you.
 

Users who are viewing this thread

Top Bottom