>Thanks, Garrett. Moving the odometer comparisons from the join condition to the where actually slowed it down, but the BETWEEN ... AND is good to know. It's a little faster than the >=/<=, and makes it easier to read the code.

Sorry about that. I just noticed that I originally posted it with the odometer comparisons in WHERE. Anyway, it runs faster with that part in the JOIN condition... Thanks again for the BETWEEN! :)

Bridget