Codings help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sreekandan
    New Member
    • Nov 2006
    • 98

    #1

    Codings help

    Hi everybody, Im doing one project, in that i have to add all the values(Integers/Double) from one selected field of the database table.So I want the code to get the sum of that field values.So kindly reply me.
  • hariharanmca
    Top Contributor
    • Dec 2006
    • 1977

    #2
    Originally posted by sreekandan
    Hi everybody, Im doing one project, in that i have to add all the values(Integers/Double) from one selected field of the database table.So I want the code to get the sum of that field values.So kindly reply me.
    You can Use

    =============== ======= QRY============ ======
    Select sum(NonStringFi endName) from TableName where ......

    Comment

    • sreekandan
      New Member
      • Nov 2006
      • 98

      #3
      Originally posted by hariharanmca
      You can Use

      =============== ======= QRY============ ======
      Select sum(NonStringFi endName) from TableName where ......
      In that coding, What is that (NonStringFiend Name) ?

      Comment

      • hariharanmca
        Top Contributor
        • Dec 2006
        • 1977

        #4
        Originally posted by sreekandan
        In that coding, What is that (NonStringFiend Name) ?

        Sorry its Non String Field Name (Numbers)

        Comment

        • Killer42
          Recognized Expert Expert
          • Oct 2006
          • 8429

          #5
          Originally posted by sreekandan
          In that coding, What is that (NonStringFiend Name) ?
          Fiend was a typo. What it means is "insert the name of your numeric field here".

          Comment

          Working...