Thanks a lot, one last question, can this be done with currency strings? Or do I have to change one of my columns to a currency column from a varchar...

Thanks for responding. But I've figured it out without it being to technical. I just modified my query string a bit. I just added another condition to...

After looking around on the net and taking your advice, I did use the HAVING clause. It worked. However, I noticed that aggregate functions are rather slow to...

When you run the first two sum statements w/o the division problem, the results are as follows:

Race ...

Thanks guys! This helps alot!