Thanks Bill,

I had just finished re-reading the primer on Join statements and found your examples to be a great addendum to what I just read.

David,

Thanks so much for your help, both queries work perfectly! Now I am working on figuring out the how and why they work and getting my mind around some...

Biju,

Thanks for the idea. That partially works by generating a list of all of the names which match one or more cities. However, if I wanted to see...