I'm assembling a list of amateur athlete performances from various competitions.
Functionally, I'd like to have a query that will assemble all the athletes names, and list all the competitions they participated in. Then I'd like a separate query assembling each athlete's achievements / performances from the competitions they participated in. The constant for this is the athlete's ID.
My SQL skills are quite limited.
Any direction will be greatly appreciated.
I'm using:
Windows Version: Windows 10
Access Version: Access 2016
- Data for each competition is assembled in separate tables, which includes multiple fields for their performance.
- The athlete ID is two fields; 'First_Name' and 'Last_Name'.
- The performance data also has consistent field names; eg. 'achievement', 'Body_Weight', 'Club'.
Functionally, I'd like to have a query that will assemble all the athletes names, and list all the competitions they participated in. Then I'd like a separate query assembling each athlete's achievements / performances from the competitions they participated in. The constant for this is the athlete's ID.
My SQL skills are quite limited.
Any direction will be greatly appreciated.
I'm using:
Windows Version: Windows 10
Access Version: Access 2016