I pulled out the SQL code and ran it by itself.
Everything was coded right, problem was in the screen/web format.
After looking, let's just call this an ID-10-T error.
Thanks for everyone's input, working now.
P: 814-472-6066 x134
172 Gateway Road PO Box 568
This message has been sent on behalf
of a company that is part of the Harris Operating Group of
Constellation Software Inc. These companies are listed at the
If you do not wish to receive any future email, please unsubscribe
by clicking on the following link:
This message is
intended exclusively for the individual or entity to which it is
addressed. This communication may contain information that is
proprietary, privileged or confidential or otherwise legally exempt
from disclosure. If you are not the named addressee, you are not
authorized to read, print, retain, copy or disseminate this message
or any part of it. If you have received this message in error,
please notify the sender immediately by e-mail and delete all copies