Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: calculate total in databases using vb6

    Hi every one
    I am new and I hope I could be as useful as yous.

    I am using vb6 to save data in access 97 now I need to calculate the total amount in field net sales and display it in lbl.caption on my form somewhere.

    Any idea?

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    How about issuing a

    Code:
    Select Sum ([Net Sales]) as Total_Amount From YourTable
    and grabbing the Total_Amount field from the recordset & putting it into the label caption...
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Thank you loquin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •