+ Reply to Thread
Results 1 to 3 of 3

Thread: SQL add returned values

  1. 10-20-2010, 12:35 PM #1
    Jollyfrog
    Jollyfrog is offline
    Registered User
    Join Date
    09-23-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    97

    SQL add returned values

    Hi i have a database and i extract a number of values from it. e.g.

    Select number1,number2,number3 WHERE value = 'example'", conn

    i want to be able to add all these values together and then output that to a given cell..

    i know how to output to a cell just want a nice simple way to add them up

    any ideas?

    thanks
    Last edited by Jollyfrog; 10-21-2010 at 06:25 AM.
    Reply With Quote Reply With Quote
  2. 10-20-2010, 01:07 PM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,423

    Re: SQL add returned values

    Why not sum them in the SQL ?
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With Quote Reply With Quote
  3. 10-21-2010, 06:25 AM #3
    Jollyfrog
    Jollyfrog is offline
    Registered User
    Join Date
    09-23-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    97

    Re: SQL add returned values

    hmm.. thats a good point,

    i'll go do that

    thanks

    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0