Results 1 to 2 of 2
Thread: Sub reports (AccessXP)
2003-03-02, 02:14 #1
- Join Date
- Jul 2001
- NJ, USA
- Thanked 0 Times in 0 Posts
Sub reports (AccessXP)
Frustration time. I have three subreports on a report. I need to add totals from each subreport so using advice I received last week I entered the following in three different text boxes.
=IIf(IsNumeric(subrptReceivablesGroup8.Report!txtG randTotal),subrptReceivablesGroup8.Report!txtGrand Total,0)
=IIf(IsNumeric(subrptReceivablesContacts.Report!tx tGrandTotal),subrptReceivablesContacts.Report!txtG randTotal,0)
The first text box gets the correct value. But the other two boxes returns #Name?
What am I missing? Or is there an easier way to add the three values from three different subreports?
2003-03-02, 03:22 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- Thanked 32 Times in 32 Posts
Re: Sub reports (AccessXP)
Are you're names correct? The subreport names are the subreport control names on the main report not the names in the database window (but you probably knew that).
Why are you using IsNumeric, how can they not be numeric?
If they can be Null I would use the NZ feature.
Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>