Query Build Help - Beginner Access User

[Derrick_0690]

Good morning everyone. I have a question regarding designing a query in MS Access 2007 that I could use some help with. I am not very experienced with this program and I think that is why I am having this problem. Please keep in mind that I do not know code or MYSQL.
I have two tables. Each table’s design can be seen below.

I need to build a query to return the total amount of hours that were spent by each role on each task. I also need to include the Project ID associated with each task as well as the associated task description. How would I go about doing this?

Resource Information Table
Initials - Text
Last - Text
First - Text
Role - Text
Email - Text

Data Table
Record Number - AutoNumber
Project ID - Number
Task - Text
Task Desc - Text
Hours - Number
Resource Initials - Text

Regards,
Derrick0690

 

[John Big Booty]

You can use a Totals Query to do what you are after. This link will give you some pointers.