Recent content by oversoul

Well I found another way to make it work also... Thank you for all the help, I appreciate it.... here is my example. SELECT Count(Result) As Total From February2005 Where Result='Won' Union All SELECT Count(Result2) As Total From February2005 Where Result2='Won' Union All SELECT...

Oh did I forget to mention, I am using Access.

Well, it worked, but it returned 2 columns. One being: Expr1000 and Totals The totals is correct, but not sure why there is a second column made.

I have a table with 5 columns that are named Result, Result2, Result3, Result4, and Result5. The values of the columns are either "Won" or "Lose". I want to count all the values in each column that have "won" and sum them to get a total of all the won values. This is what I have, and it is...