Query design help

[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

 

[Van T. Dinh]

See The Access Web article:

http://www.mvps.org/access/queries/qry0020.htm

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Thanks heaps for referring me to that article. With a bit of tweaking, it
worked beautifully!!!

Thanks again!
Winsa