Forum Discussion
Pisano4980
Apr 26, 2023Copper Contributor
Query Search (New to Access)
I am new to access and am attempting to use it to track workouts to learn and be more proficient for work.
The table I have is "Date", "Exercise", "Sets", "Reps", "Weight".
I would like to run a query that picks 3 exercises, "Squat", "Bench", and "Deadlift" and shows me the Max recorded "Weight" recorded if "Reps" 1 through 10. I only want up to 10 records per Exercise, for only those 3 exercises. Any help would be appreciated. I have no knowledge of VBA and I have been trying to do it strictly through Query Design.
No RepliesBe the first to reply