I used a sum command and it worked great... I just had to handle the current table views but it works fine. I have been trying to get away from data manipulation using anything other than Select statements, but it appears that I had no choice in this circumstance. Thanks for the help.

Rick