Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tsiegle
-
Selecting most recent of dupe transactions
Thank you, but I already tried that. If I do that it also groups on TranSourceCode which is usually different for each transaction so they both come back, not just the most recent. This results in pulling these two records: donorid trandate... -
Selecting most recent of dupe transactions
What I am trying to do seems so simple, I am not sure why I am having trouble. I am trying to get the Highest transaction amount for each of our customers, however many times they give the same amount every month so in that case I need to find their single highest transaction with the latest...
