Re: Data Problem in Report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

mk2 wrote:

>I have a report that displays in the following order:
>
>Date Range - Sample Data: 10/01/2005 - 12/31/2005
> Event Name - Sample Data: 2005 Ohio High School State Tournament
> School - Sample Data: Notre Dame High School
> Player - Sample Data: Anderson, Melissa
> Smith, Lydia
> Wilkes, Candace
>
>The report for the most part works fine. However, for certain schools only,
>the players are listed twice. So the report looks like this:
>
>Date Range - Sample Data: 10/01/2005 - 12/31/2005
> Event Name - Sample Data: 2005 Ohio High School State Tournament
> School - Sample Data: Notre Dame High School
> Player - Sample Data: Anderson, Melissa
> Anderson, Melissa
> Smith, Lydia
> Smith, Lydia
> Wilkes, Candace
> Wilkes, Candace
>
>I have confirmed in that the player record does not have a duplicate in the
>source table. I have also confirmed that the High School does not have a
>duplicate in its source table. I cannot find anything in the data entry that
>would trigger the players for certain schools to be listed twice. I would
>think that if something was wrong in the formatting of the report, that every
>player for every school would list twice.
>
>Interestingly, I have another version of this report that adds a component
>called Evaluations. It contains all of the above information in addition to
>the Evals component. In this version, the player doesn't list twice, but the
>Evaluation for that player does. Again, this only occurs for the players from
>the high schools discussed above.


Try opening the report's record source query directly from
the query design window.

I'm thinking that maybe there's something about the Join
that's picking up the player entries twice for some scholls.
It might be simpler to spot the problem if you remove the
report from the issue.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Data Problem in Report
    ... Is the Player table the most detailed record or does the Player table have ... > Event Name - Sample Data: 2005 Ohio High School State Tournament ... > The report for the most part works fine. ... > would trigger the players for certain schools to be listed twice. ...
    (microsoft.public.access.reports)
  • Lt. Col. Grossman: Virginia Tech Tragedy Report Misses Point
    ... Col. Grossman: Virginia Tech Tragedy Report Misses Point ... A leading expert on mass violence has taken issue with a presidential task force report delving into the Virginia Tech shootings and school violence in general, saying it fails to address the key issues. ... The kids that gave us Jonesboro in the middle school and Columbine in the high school are now showing up in the colleges. ...
    (alt.politics)
  • Fw: "DONT BELIEVE YOUR REPORT CARDS."
    ... "DON'T BELIEVE YOUR REPORT CARDS." ... Hizon, revered faculty, graduates of Class 2007, parents, relatives, and friends, good evening. ... When I was 3rd year high school, I was called to the principal's office in the middle of class. ... The other thing measured by your report card is effort--how hard you work. ...
    (soc.culture.filipino)
  • Re: College basketball injustice
    ... And simply put, high school in this ... > player more prepared to be an NBA player. ... If I thought that the new age limit would lead to great ... >> women are allowed into the women's restroom is unfair to men, ...
    (rec.sport.basketball.college)
  • Re: physics experiments
    ... The lab part of the courses doesn't seem to interest the ... >> students all that much and I don't really blame them. ... not high school) for my generation was a strict ... That report was _the_ driving ...
    (sci.physics)