Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    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(subrptReceivables.Report!txtGrandTo tal),subrptReceivables.Report!txtGrandTotal,0)
    =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?

    Thanks. Fay

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •