What I have
3 tables
Projects
Tasks
Owners
Tasks are linked to Projects via FK (Project PK)
Both Tasks and Projects have FKs, that are the Owners PK.
I am trying to create a query to be used to build a report where Tasks are grouped by Project, and each Project and Task Owner is also shown.
My query skills are the most meager of my already meager Access skills, so I have been fighting with getting a working query all morning. Any help is greatly appreciated.
3 tables
Projects
Tasks
Owners
Tasks are linked to Projects via FK (Project PK)
Both Tasks and Projects have FKs, that are the Owners PK.
I am trying to create a query to be used to build a report where Tasks are grouped by Project, and each Project and Task Owner is also shown.
My query skills are the most meager of my already meager Access skills, so I have been fighting with getting a working query all morning. Any help is greatly appreciated.
Join Error Help
0 commentaires:
Enregistrer un commentaire