Query Help - Beginner User

[Derrick0690]

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?

Regards,
Derrick0690

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

[Robeen]

1. Create a New Query in Design View.
2. Select your two tables.
3. Drag the Initials field from one table to the other in the design window to create a join between the two tables.
4. Double-Click each of the fields from the two tables that you need to see in your query [this should put the fields in the query pane below].
5. Sort your query by Initials [hopefully no two people have the same initials - or name], and then sort by Task.
6. Run your query.

If you have the right data, then you can Group your results by Resource and Task and do a Sum on the Hours.

Let us know if you have problems.