A person can only have 1 value per day column, so the other rows for that day are null. I could not figure out how to get that query to work so i converted them to numbers and i'm summing. I then just convert them back to the character equivs in a "decode" table. But, I really appreciate...