G
Guest
Hi
I hope someone can help me with a query.
I have a table that records payments with the following fields: Debtor,
Transaction_Date, Amount (among others, but I'm trying to keep this post
simple).
I basically need a query that finds the most recent payment, ie. if a
debtor's last payment was $100 on 3 May, I need to be able to pull up just
this information and not any payments previous to this date. The problem is
that there are many payment entries for each debtor. I tried using the MAX
function (?), but that didn't seem to work, I was getting all payments for
some reason. I don't want a sum of the amount either, just the actual amount
relating to the last payment.
I hope I've made myself clear!
Regards
Winsa
I hope someone can help me with a query.
I have a table that records payments with the following fields: Debtor,
Transaction_Date, Amount (among others, but I'm trying to keep this post
simple).
I basically need a query that finds the most recent payment, ie. if a
debtor's last payment was $100 on 3 May, I need to be able to pull up just
this information and not any payments previous to this date. The problem is
that there are many payment entries for each debtor. I tried using the MAX
function (?), but that didn't seem to work, I was getting all payments for
some reason. I don't want a sum of the amount either, just the actual amount
relating to the last payment.
I hope I've made myself clear!
Regards
Winsa