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 Text
Data Table Record Number AutoNumber Project ID Number Task Text Task Desc Text Hours Number Resource Initials Text