Use DMAX in query

[sarahjh]

I am not knowledgeable in VBA or SQL. I've never used the function dmax before, though I've tried and cannot get the structure correct, and need help in using this in a query. In the table [event_history_view] are listed various events ([event_code]) associated with each claim_pk. Each event has a scheduled due date.



From the table I want to get the event for each claim_pk that is furthest in the future. These are the tables and fields ([table].[field] ) I'm working with:

[event_history_view].[claim_pk]
[event_history_view].[event_code]
[event_history_view].[current_sched_date]

Each permutation I try results in an error. Can someone help me?

[pbaldy]

Would this work for you?

http://www.baldyweb.com/LastValue.htm