Kevin,
Good morning (from where I am)! Actually, I posted a reply w/o reading the message completely. After I made the post only then did I notice that you had already replied and that it worked. What I actually posted was the syntax for using the DISTINCT keyword, which ofcourse will not apply to the problem since he probably needed to post some totals. My bad 8)
Just goes to show that I need some coffee... lol!!!
Shit happens!!!