Top Values

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hi All: Trying to have a footer field that will only total top 2 values of
grouped data above. For example : I have a reprt that shows 2 people
grouped, and each person can have multiple scores: 21, 22, 25 etc. I want
its footer to add just the 22 & 25 for that person and the other persons
footer to add its top 2 scores. Anyway to do this topvalue on a sum field in
the footer. or am I going about the wrong way. I tried using a top Value
query but it only reports the top two values of "all" scores not top two of
a given week or group as in report.
Any help or did I confuse all?
 
Hi Ed.
You can do this by creating a cubreport and link the subreport by whatever
grouping you have.
Give that a try.
Hope this helps.
Fons
 
Thanks for trying to help. If your familar with Trap shooting, thats what
I'm trying to set up database for league. Let me simple it down for me. I
have a score keeping database.
Member table, Rounds table, One to many. The rounds table can have as many
records as the member shoots that week. I want the report to display only
top 2 rounds and total for that week. so the detail section would display
top 2 scores for week 1. then top 2 scores for week 2 etc... I have a field
in each round for week number.
 
Hi Ed, That sounds like fun.
Any way, the way to approach this is to create a report for the Members,
grouped by member with a footer per member, than in the memeber footer insert
a subreport, I would probably create a generic subreport based on the Rounds
table linked by the meber number.
Now open the subreport in design view and modify the source query order by
score descending and to show only the top two
records.
This should do it.
Fons
 
Back
Top