Get totals from sub report to main report

T

ToniS

I have a report with 2 sub reports on them,
Main Report
Sub Report1 contains Fee Totals (A textbox contains this information)
Sub Report2 Contains Payment totals (A textbox contains this information)

On the main report I would like to show a balance due: fees - payments.

This is what I have so far in at textbox on the main form I set the text
field control source to =[sub report1].[Report]!FeeTotal - [sub
report2].[report]!paymentTotals

The text box displays #name? I even tried just displaying the total fees on
the main form as follows: =[sub report1].[Report]!FeeTotal I still get
#name?

Any ideas on what I am doing wrong?
Thanks
ToniS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top