Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subreport Shows Values Repeatedly (2003)

    On the startup form of the attached mdb, please click the "Report" button,
    How come the RMeteo subreport displays the rows in its detail section multiple times?

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

    Re: Subreport Shows Values Repeatedly (2003)

    Because the Meteo table contains multiple records for one day.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport Shows Values Repeatedly (2003)

    Wow, that's tricky because I need to have 3 measurements per day. Isn't there a way to get rid of the repeating rows in the report?

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

    Re: Subreport Shows Values Repeatedly (2003)

    Since all of the text boxes contain DLookup formulas, the subreport desn't need to be bound to a table. In fact, you don't need a subreport at all. Neither do you need the dummy sections.
    See attached version.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport Shows Values Repeatedly (2003)

    Thank you very much Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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