MOST recent date

[pht204]

Hi there,
I have a list of date on my table:
ClientName
ClientPurchase
PurchaseDate
PuarchesItems

Let's say, the purchas dates are multiples and I want to get each
clients with their most recent purchase dates. What is the
function/string used in MS Access?

I am pretty novice and would appreciate any help; even in the correct
usage of Access terms.

Thanks,
Krys

[Allen Browne]

1. Create a query that uses this table.

2. Depress the Total button on the toolbar (upper sigma icon.)
Access adds a total row to the grid.

3. Drag ClientName into the query output grid.
In the Total row under this field, accept Group By.

4. Drag PurchaseDate into the grid.
In the Total row, choose Max.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ph****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi there,
I have a list of date on my table:
ClientName
ClientPurchase
PurchaseDate
PuarchesItems

Let's say, the purchas dates are multiples and I want to get each
clients with their most recent purchase dates. What is the
function/string used in MS Access?

I am pretty novice and would appreciate any help; even in the correct
usage of Access terms.

Thanks,
Krys