By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,718 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,718 IT Pros & Developers. It's quick & easy.

MOST recent date

P: n/a
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

Dec 14 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Dec 14 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.