Find first record

A

Alan Mitchell

I am using Access 2000.

I have a table which records conversations with clients.

Each client may have multiple conversations.

I am looking for an easy way to produce a report showing the most recent
conversation for each client.

I am by no means excperienced in Access and haven't used much code so any
solution would ideally use the standard menu-drivern functionality of Access.
I could probably pick my way through some coding given sufficient detail.

Any help would be greatly appreciated.
 
S

Steve Huff

You basically need to understand how to create a query of your data. If you
want to do it visually:

- you would create a new query and add the table.
- under view select "Totals"
- on the Field drop down select the fields you want shown such as client
name
- under fields such as client name select "Group By" for the Total Row
- Add the conversation date field and under that Select "Max" for the Total
Row

Run The Query and you should have the client name with the lastest
conversation date.

--Steve Huff
 
A

Alan Mitchell

Steve

Thnak you very much. What you suggested worked perfectly.

I found a very crude solution using "No Duplicates" in reports, but your
solution is much, much better.

Thanks once again.
 
Top