Thanks for replying.
tarcona, i did something like you did. But it still does not deal with the issue that it shows blanks for records that were dealt with by inactive employees.
dkinley, thanks for the help. I'm going to try your suggestion, I will let you know how it works out.