MOST recent date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pht204@gmail.com - 14 Dec 2005 04:00 GMT

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

Reply to this Message

Allen Browne - 14 Dec 2005 04:49 GMT

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.

Signature

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.

> Hi there,
> I have a list of date on my table:
[quoted text clipped - 12 lines]
> Thanks,
> Krys

Reply to this Message