WayneRyan, that worked perfectly. I simply moved it to the first statement. Also: sorry for the long delay, I've been out of town on a job and haven't been able to work on this project in a bit.
Like I said, still learning my way through SQL, and the "As A, B, etc." is new to me. I'll...