Thanks for all the help! I used Luis's example to help wrap my head around it and incorporated it into my main query and it works great.

Just started...

Thank you for all the responses, I will work on changing (and understanding) the examples and incorporate it into my actual query. =)

Cheers!

Morning,

Can you please type a example of how you would change my query to rejoin locations? i keep trying to rejoin the table but getting repeating and/or duplicating the elat/elong...

Ok I will try that, the data/columns and such are all made up, so no ops concerns.