Adding from subreport to main report

SPDurie

New member
Local time
Today, 14:50
Joined
Oct 28, 2001
Messages
7
I know this must be an easy one, but I can't figure it out for the life of me.

I need to subtract the total from a field in the subreport from a field in the main report.

Any thoughts?
 
Result = Val(Me.subReportName.Form.subtxtBoxName) - Val(Me.maintxtBoxName)
 
Thanks that worked great!

But it caused a new problem...the problem of -0-. How do you get rid of "#Error" when there's no data to work with?
 
Clarify this for me. Do you mean when one or the other field contains a null value? What value do you want to return in this case? Do you want the formula to treat a null value as a 0?
 
Question:
You said to write your expression like:
Result = Val(Me.subReportName.Form.subtxtBoxName) - Val(Me.maintxtBoxName)

What does the .Form. in there do? If you are pulling from a Report why do you use form...?

I could use this answer.
 

Users who are viewing this thread

Back
Top Bottom