Results 1 to 2 of 2
2003-02-13, 15:17 #1
- Join Date
- Oct 2002
- New Salem, North Dakota, USA
- Thanked 0 Times in 0 Posts
Function to sum certain data (2000)
Here's the problem...not a big deal...not a work deal...
Have a table containing people, their team, date, and their score. Creating report broken by team...no problem. Report will show all team members and their scores...no problem. At the bottom I need to sum things up, however instead of summing ALL the scores, I just wanna sum the top 4 scores of all those shown...problem!
Any ideas on how to do this?
2003-02-13, 15:23 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Function to sum certain data (2000)
You can create a TOP 4 query. In design view, make sure the Properties window is displayed. Click in an empty part of the top half of the query window. Then enter 4 in the Top Values property (the dropdown list only provides a limited number of choices, but you can enter other values manually).
Use this query as record source for a subreport in the report footer, or put a text box in the report footer with a DSum based on the query.
Post back if you need more instructions, or if I have misunderstood your question and this is not what you want.