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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing totals in a query 1
Transposing Tasks in a Report (summarizing common tasks) 1
Writing to one table with two different subforms? 0
Read a table and take action 2
How do I read a table and taken action? 3
I want multiple formulas to always extract from same cell(s) 1
Yet another query question... 2
Writing a query to return only rows that are null 2

Top