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.


you can try to use the sql statement to retrieve the total number of ppl.
SELECT COUNT(*) FROM pr_mod8 WHERE completed = 1
hope this statement if useful for you.