Calculate a variance between main report and subreport???

[Apollo6]

Main Report >> rptMain
Subreport >> rptSub

rptMain has a text box (not caluculated on report) >> txtAllowable...

rptSub has a text box (not calculated on subreport) >> txtSubAllowable...

What is the syntax to subtract txtSubAllowable from txtAllowable???

I tried the following:

=[Reports]![rptMain]![txtAllowable]-[Reports]![rptSub]![txtSubAllowable]

I also tried the same expression without explicitly naming the main report...

Any help is appreciated.

 

[dhookom]

As a control source for a text box in the main report, try:
=[txtAllowable]-[subrptControlName].[Report]!{txtSubAllowable]
The subrptControlName is often the name of the subreport.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.