Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: originalclassic
- Order by date
-
How do I Count() totals across multiple fields?
Terry, I got the first piece of code working beautifully, but I am having trouble with the second. I did everything as you said (and it is quite a sneaky little bit of code by the way) but MS SQL keeps giving me errors on the SUM function. I have mine set up like this: sum(Case Val When '10...- originalclassic
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How do I Count() totals across multiple fields?
Terry, Thanks for the quick response. I tried playing with the code that you posted for me, but it seems like i did not give you enough information from the beginning. In the end, the report we want to generate should be a large table that lists the values of the 7th column down the left side...- originalclassic
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How do I Count() totals across multiple fields?
In my data table i have six columns(A-F below) that i need to get count totals from. Each cell contains one of 20 preset values(1-20below). The first column always has one of the values, but each additional column may or may not depending on the complexity of the original entry. I am trying to...- originalclassic
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
