Distinct Records & DSUM

[AJD10]

I'm having mental blocks on this task.

Data table looks like this:
Estimate Hours:
ID TASK Rev Date Hours
1 Analysis 07/01 12
2 Develpmt 07/01 40 *
3 Support 07/01 32 *
4 Analysis 07/02 10
5 Analysis 07/05 15 *


I want to get the total hours for Analysis, Dev, Support using the most recent entry (the ones starred).

I used DSUM to get a total for the whole table, but I need to get the distinct Tasks with the Max Date.

Any advice on doing this succinctly?

 

[mikeyb540]

Use a CrossTab Query

Task as Column Heading (Group by)
Hours as Value (Sum)
Rev_date as Row Heading (Group by)
whatever the * field is as criteria as