>Naomi,
>
>Thanks for the advice on "multiple steps." I am finding that the more I get into this project, I will likely have to do this in multiple steps. I will probably start another thread soon coming at it from a different angle. And thank you for the info on the LEFT JOIN articles.
You're welcome.
If it's not broken, fix it until it is.
My Blog