Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation from sub-report (2003+)

    I'm looking to have a calculated text box on a report that give the Max of a field that's on a sub-report of a sub-report.

    At the moment, I've yet to figure this out.

    Any ideas????

    PS the report is "Report1", in the attached.

    TIA
    Attached Files Attached Files

  2. #2
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation from sub-report (2003+)

    Oops, should've been a bit more descriptive on the control that I wanted to work; it's 'Text25' up by the title label.

    Cheers

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation from sub-report (2003+)

    You can't do it that way. You could use the DMax function to get the maximum score directly from the qrySybHNS query:
    <code>
    =DMax("Score","qrySubHnS")</code>

  4. #4
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation from sub-report (2003+)

    Thank you Hans, just the ticket

Posting Permissions

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