Florian Reischl (9/11/2011)

---

Hi

Since all your facility tables have the same structure, I would try to centralize your query logic. If you need this UNION ALL only in one script/procedure, I'd...

Welsh Corgi (9/11/2011)

---

Please don't take offense but it would be easier on the eyes, shorten the length of your statement and make it easier to identify an issues by using...

Thanks a million! I have been looking over this since yesterday afternoon! I guess I just needed a fresh set of eyes! Thanks again! That was...

Unfortuntely, there is a limit of 7. I made a response in another form as to alternatives. See: http://www.excelforum.com/excel-worksheet-functions/637114-more-than-7-if-statements.html