You are awesome. This is good stuff!

Ok, let's see if I can break this down...

For each route, there are multiple Activities (pick or drop). For every pick there...

I'm open to hearing whatever you got.

As far as the temp table goes, I technically could've used joins but it was much simpler for me to use the view which...

Oh! and I read your post on the sample data....but I'm not quite sure how to go about doing that for this exercise. I wouldn't know where to begin. (eek!...

Ok, here goes... let me know if i need to clarify. (and thank you for your help!)

------To find actual mileage based on odometers:

----FILL TEMP TABLE WITH ALL RECORDS FROM...

These are great queries, thanks everyone. It just seems I've opened up a whole new can of worms with this. Apparently my subscriptions are scattered throughout several servers,...

Thank you for the info! I'll give it a try.