Date Function needed to pull most current date - - URGENT

[Danny]

Ok. I have a query that pull payment information which
includes: payment code (i.e. 701), date, amt, etc. The
payment codes are specific to my criteria, however if
there is a recent payment infront of my desired pymtcode
(701), then I don't want to pick it up.

I.E. I don't want to pick up this record because there
is a most recent payment.

date pymtcode amt
8/18/03 701 25.00
8/30/03 510 50.00

However, I DO want to pick up this record because it meets
both criterias. (Criteri being: most recent date &
specific payment code)

date pymtcode amt
8/18/03 510 50.00
8/30/03 701 25.00

Thank you in advance.

 

[John Verhagen]

As the date criteria, put:
DMax("[Date]","tblXXX","[ID]=" & [ID])
where ID is the ID associated with your payments, and tblXXX is the name of
your table.