Jeffrey Williams (7/21/2008)
The alias t1 was used in the sub-query and I didn't remove it. Modify the sum statements and change the reference from t1 to t and that should do it.
**Ding**Ding**Ding...we have a winner!
Man, thank you so much for your patience and help Jeffrey...the data looks great. Sorry for not being so clear from the beginning.