2 Replies - 7936 Views - Last Post: 25 July 2011 - 12:49 AM Rate Topic: -----

#1 Pertoh   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 31-August 09

Getting Sum from Access Table and Posting Total Value in a Label?

Posted 17 July 2011 - 01:43 PM

Hello Experts. How do i add up a column in an access database table. I have a table called temp and a field called total.. How do i add up all the values of that field and show the total in a Label???
Is This A Good Question/Topic? 0
  • +

Replies To: Getting Sum from Access Table and Posting Total Value in a Label?

#2 raziel_   User is offline

  • Like a lollipop
  • member icon

Reputation: 469
  • View blog
  • Posts: 4,280
  • Joined: 25-March 09

Re: Getting Sum from Access Table and Posting Total Value in a Label?

Posted 18 July 2011 - 07:39 AM

use sum() access method
http://www.webcheats...nctions/sum.php
Was This Post Helpful? 0
  • +
  • -

#3 leixnt   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 30
  • Joined: 24-July 11

Re: Getting Sum from Access Table and Posting Total Value in a Label?

Posted 25 July 2011 - 12:49 AM

recordset = "select sum(total) total from temp"

label1.caption = recordset!total

This post has been edited by leixnt: 25 July 2011 - 12:50 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1