Data Problem in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

Can somebody give me some idea what is going on and how to fix it????
 
Is the Player table the most detailed record or does the Player table have
lookups or children tables?
 
mk2 said:
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.
Click to expand...


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.
 
In the first report, 3 of the Player table fields that are used in the report
are lookup fields - Rank, Tier and Position. These are combo box fields; they
are not lookup fields to another table.

In the second report, the Evaluations table is the source of the detail
section of the report. The Evals table does contain a lookup to the Eval
Sites Table. The Eval Site field is used in the report.
 
Do you possibly have the Evals table in your report? Do you have more than
one eval record per student? Do you need eval in your report? You didn't
show the evals in the display of your first posting.
 
Back
Top