Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: Accumulating Totals in a Query, HELP!

    I need help writing an expression in a parameter query.

    I need to be able to run a query that brings the total dollar amount or greater for a date range, but I need the total to accumulate before grouping.

    The user inputs the minimum amount and the date range.

    Example: I ran a query for all donors who donated $500 or more between 01/01/04 and 03/01/04. The query won't bring back donors with donations totaling $500.00 or more, it only brings back donors who actually wrote a check for $500 or more.

    This is what my fields are:

    FIELD: DonorID, TABLE: Contributors, TOTAL: Group By

    FIELD: $Amount, TABLE: Contributions, TOTAL: Sum, CRITERIA: >=[Enter the Minimum Amount]

    FIELD: ContributionDate, TABLE: Contributions, TOTAL: Group By, CRITERIA: Between [Type the beginning date:] And [Type the ending date:]


    Please help if you can.

    M Marbury

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    What you seem to bae requesting is difficult to do in a query, but is easy to do on a report. The only way I have found in the past is to use union queries and a creative sorting scheme. I think it was in a book called Access97 power programming.

  3. #3
    Join Date
    Aug 2004
    Posts
    2
    Thanks for the advice.

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I believe ContributionDate should be Where instead of group by, in current format it will group by Donor ID and Date together. If if a donorid have 2 records for 2 different days in the date range, donorid will be show up twice.
    ghozy.

  5. #5
    Join Date
    Aug 2004
    Posts
    2
    Thanks Ghozy, I will try that.

Posting Permissions

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