S SPDurie New member Local time Today, 14:50 Joined Oct 28, 2001 Messages 7 Nov 8, 2001 #1 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?
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?
O ott Registered User. Local time Today, 14:50 Joined Nov 2, 2001 Messages 33 Nov 8, 2001 #2 Result = Val(Me.subReportName.Form.subtxtBoxName) - Val(Me.maintxtBoxName)
S SPDurie New member Local time Today, 14:50 Joined Oct 28, 2001 Messages 7 Nov 8, 2001 #3 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?
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?
O ott Registered User. Local time Today, 14:50 Joined Nov 2, 2001 Messages 33 Nov 8, 2001 #4 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?
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?
Randomblink The Irreverent Reverend Local time Today, 08:50 Joined Jul 23, 2001 Messages 279 Nov 9, 2001 #5 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.
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.