Getting Count of several groups 2

[Gatorajc]

I have a table that looks like this well at least part of it does.

Time Area Work Date
----------------------------------------
1 Payments Tickets 1/9/03
1.5 Other Development 1/9/03
.5 Payments Development 1/9/03
.25 NT R&D 1/10/03
3 Payments Development 1/9/03

Work is a sub section of area. I want to be able to sum up the time for each Area broken down by Work.

So I want to get a result like this.

Payments Tickets 1
Payments Development 3.5
NT R&D .25
Other Development 1.5

I know I will kick myself when I see it but I just cant get the right statement to get this result.

Thank You in advance for any help.
AJ
I would lose my head if it wasn't attached.

 

[swampBoogie]

select area,work,sum(time) as totalTime
from t
group by area,work

 

[osjohnm]

Hi

This should work:

select area, work, date, sumtime)
from table
group by area, work, date

Hope this helps

John

 

[osjohnm]

Hi

You can take out the DATE column as this wasn't part of your requirement. And sorry for the typo..it should be
sum(time)

John