Thanks Drew, I see how much more efficient that would be. I'll have to ponder this, I was really hanging on to using views because that will allow the Access...

That could be true, but, this is not a real time transactional system, our small team is focused on reporting and analysis. We're working with tables of less than 1M...

Thanks Drew. I know I could use various techniques to fix this particular situation, but I'm concerned that this issue will raise its head in other queries as a subtle...

Thanks for the reply. I guess after years of MS Access experience using nested queries, I had never run across the case where a "WHERE" got processed in an order...