How do you write to a temp table? I was thinking of having a column with the old meet for the first query and then another for the new meet....

Steve, Is there an easy way to show the differences of the motivational type if I wanted to compare two or more meets together? The only thing that would change...

Thank you again, I really appreciate your willingness to help me out!

Oh my, it works!!!!!

I cannot thank you enough!!!! You have saved me a many man hours trying to filter and cut down a big list!!!!!

Thank you, thank you, thank...

A little. What you provided is way above my knowledge base. I can mostly write the type of queries I need to pull data from a meet that I need,...

Thank you, this returns the one row for a test case! Is there a way to apply this so it would return the highest level row for a meet for...

Holy cow, thank you so much! This is very close!!!

There seems to be some duplicates returned from the query, sometime 2 times, other times 3, some 4 times.

Times with...

This is what was returned when applied to the competition.

last_Namefirst_nameAgeEventMeetmotivational_descriptiontime_standardmin_agemax_ageFinished Time

StimesKelsey16200 I.M.DCST @ WDSTAA2:19.7916162:18.92

This logic sems to work when it applied looking for the highest total level motivation_description. I would...

On a test case with one person with one event it did work. I would like this to return the highest row. A person can do multiple events. When I...

It did on my test case momentarily and then when I applied to my larger population it didn't.

I am not sure what happened. I am not sure where to go...

This sorts it by the motivational type, but if someone has a 'AAAA' value returned, I don't want any of the other times returned. I want to keep the highest...