Sum in query

  • Thread starter Thread starter Ayala
  • Start date Start date
A

Ayala

Hi all,
I have a query which displays Name, Activity and Hours.
E.g.
Name Activity Hours
Smith Meetings 2.00
Gonser PLC Programming 4.5
Durek Meetings 3.5
Ramon Courses 8.0
Ayala Meetings 1.25

How can I build an expression in order to get the sum of
hours for people doing the same activity?? In the last
example I would like to get Meeting hours: 6.75 and so on
for every activity.
thx.
 
Select Activity, Sum(Hours) from MyQuery group by Activity
(not checked using Access, but it should work)
 
Back
Top