Summing totals in a query

R

Rudi

Hi,

I have a query thats returns specific entries in a table with a few project
and Hour fields. A user is able to choose from a list of projects for each
field. I want to count the amount of hours for each project. From a form,
the user is asked to choose a period for which the want the query to run. A
result a typical query is displayed below.

Name ProjectsA HoursA ProjectsB HoursB
ProjectsC HoursC

User1 Project1 3 Project2 5
Project1 1
User1 Project2 2 Project2 3
Project1 2
User1 Project1 1 Project2 7
Project2 3

Now, I want the totals (preferably in a report)

Totals for User1 for Period A

Projects TotalHours

Project1 7
Project2 20

How do I do this?

Thanks!
R
 
Top