I have my exercise database designed and I wanted to make a report which will show all of the exercises a specific member has scheduled within a 2 week period from the current day.
I want to display the following information:
Membership No
First Name / Last Name
Date of Workout
Exercise Name
Sets / Reps
Time / Distance
I have all of the tables sorted I just need to try and get my head around how to make a query to do a report like this, any help would be greatly appreciated!.
Database attached, all the tables used for the Workout part use the tbl prefix.
I want to display the following information:
Membership No
First Name / Last Name
Date of Workout
Exercise Name
Sets / Reps
Time / Distance
I have all of the tables sorted I just need to try and get my head around how to make a query to do a report like this, any help would be greatly appreciated!.
Database attached, all the tables used for the Workout part use the tbl prefix.
