keep rows with most recent date

R

Richard

In my database, each row corresponds to a new purchase or ammended purchase.

The key fields are:
purchase number
purchase linenumber
date
description
amount

When a purchase is fist entered, it is given a purchase number and
linenumber which never vary, plus a date, description and amount. Later, if
someone changes their mind, a new entry will be made with the same purchase
number and linenumber, but the description or amount will be different.

I want to keep only the rows that have a given purchase number and
linenumber but with the most recent date.
 

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

Top