Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Unhappy Unanswered: Can't find unique records, max values

    Help, please. Have worked with Paradox 9 for a number of yrs, creating fundraising tracking for local private school. Have never done programming with it, but use various queries, linked tables, etc. THis is volunteer stuff. Problem: Unkeyed table with Members (ID#), 1 record for each year of giving with Amt1 and Amt2. I want to pull out one record per ID# for the year with the highest total giving (Amt1 + Amt2) of the records. Cannot figure out how to get the highest amount out of multiple records for each member. Would love to be able to do this is in one step rather than multiple queries. And can I also link it to the Master Table to get names and addresses for that Member Id? Thanks.

  2. #2
    Join Date
    Dec 2007
    Posts
    369
    asked and answered on the paradox community forum..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

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