Query Search (New to Access)

Copper Contributor

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. 

0 Replies