I would like to know how to display the totals of fields in a given table using vb or SQL. I have a page that I'd like to display the number of people who have completed training. In my database this is determined by a field called pr_mod8. If the value of this field is 1 this means they have completed training. I'd like to add up all the fields that the value 1 and display the total in my web page.
I'm new with .NET so I'd appreciate the simplest explanation and answer.
Thank you all.