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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query - 10
show the most recent payment 5
How do I find the last record ? 5
Subquery not integrating to query to display previous sum of quantities 3
Query Help One-to-Many 4
Can't solve this query problem. 3
The query cannot be completed. 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0

Back
Top