Member Avatar for marequi

Hello,
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.

marequi

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by chewmp
Member Avatar for chewmp

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.