subform query

[damie]

I have an access form with a subform in it. The form is from a list of clients with their respective details and the subform is made up of calls made to each client with commentaries attached to each call.
I want to produce a query which will, for instance, list all the client names plus the very last call made to that client with the commentaries of that last call.

Specifically, my problem is that I don't know how to request that just the last call of each client appears.

I'm hoping someone can point me in the right direction.......


Thanks.

 

[Mile-O]

Use a Totals query to select the Max of the time called field.

 

[damie]

I think what you have told me has worked just as hoped for. Thanks very much for the help!