Show Duplicate Scores

[Guest]

I created a report that shows golf scores for each tournament. It displays
the 9 hole scores as shown below

June 2, 1999 40


If I shot the same score that same day, only one of the scores shows up on
my report(in Tournament Score Footer). How do I get it to show duplicates?
I checked under Properties and the Hide Duplicate is set to No.

 

[Joseph Meehan]

I created a report that shows golf scores for each tournament. It
displays the 9 hole scores as shown below

June 2, 1999 40


If I shot the same score that same day, only one of the scores shows
up on my report(in Tournament Score Footer). How do I get it to show
duplicates? I checked under Properties and the Hide Duplicate is set
to No.

Is the second score being saved in the table? Is the score field
indexed (no duplicates) in the table?

 

[Guest]

I'm running this off a query and both scores show on the query. I actually
have a Sum set up in the year footer of the report where it will give me my
18 hole score and that adds up the two dulicate scores. So the report only
shows one score of 34 in the Tournament Footer, but the 18 hole score shows
as 68 in the year footer.

 

[Joseph Meehan]

I'm running this off a query and both scores show on the query. I
actually have a Sum set up in the year footer of the report where it
will give me my 18 hole score and that adds up the two dulicate
scores. So the report only shows one score of 34 in the Tournament
Footer, but the 18 hole score shows as 68 in the year footer.

Does that report do any grouping?

 

[Guest]

Yes. I have a Group Footer for Tournament Score that has the date and score
in it. Also have a Group Footer for Year that sums the 2 scores in that year
to give me the 18 hole score I mentioned before.

 

[Guest]

Joseph,

I answered my own question when I submitted my last reaponse. I had the
date and score in the footer. Moved to Detail and it works now. Thanks.

 

[Joseph Meehan]

Joseph,

I answered my own question when I submitted my last reaponse. I had
the date and score in the footer. Moved to Detail and it works now.
Thanks.

Thanks for letting us know it worked.