Then I am back to where I started. I will work on the field trip one today and get back to you.

>Ok, try both selects without the first part before UNION. I think for these two select statements they are not needed. Also you may want to try to simplify these selects (or start building them from simplest to complex) until you find the offending piece. Right now it's still hard for me to figure out what the problem may be.