Query-how to keep one record with the oldest payment date

J

Jean

Hi I am going to illustrate what i am trying to do in an example. I have the
following results from a query:

Payment# Account # Payment Date Payment Amount
1 1000 4/2/2007 $500
2 1000 4/4/2007 $300

What I would like to do is just keep the record with the oldest payment
date, in this case Payment# 1, any help is greatly appreciated!

Thanks a lot!
 
M

Maurice via AccessMonster.com

Do you want to delete the other records or do you just want to see the
'oldest' one.
If you create totals by pressing the 'Totals' button you can get your answer
by setting the grouping to MIN in the datefield.

Maurice
 
Top