Results 1 to 2 of 2
  1. #1
    Star Lounger
    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 problem. Report will show all team members and their 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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts