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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.