Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

SQL Question

  • 23-11-2007 04:00PM
    #1
    danindublin
    Closed Accounts Posts: 230 ✭✭


    Having a bit of a brain dead day. In MS Access

    Trying to add fields with a record but its just ignorning it.

    e.g.

    Name Value1 Value2 Value3
    _______________________________________________

    Daniel 300 200 500


    Want it to spit out 800 basically

    Been using : SELECT Name, (Sum(Value1)+Sum(Value2)+Sum(Value3)) AS Expr1
    FROM main


Comments

  • #2
    FindingNemo
    Closed Accounts Posts: 345 ✭✭FindingNemo


    here you go,

    SELECT testtbl.name, Sum([v1]+[v2]+[v3]) AS Expr1
    FROM testtbl
    GROUP BY testtbl.name;


    you're missing the group by
    danindublin wrote: »
    Having a bit of a brain dead day. In MS Access

    Trying to add fields with a record but its just ignorning it.

    e.g.

    Name Value1 Value2 Value3
    _______________________________________________

    Daniel 300 200 500


    Want it to spit out 800 basically

    Been using : SELECT Name, (Sum(Value1)+Sum(Value2)+Sum(Value3)) AS Expr1
    FROM main


  • #3
    bonkey
    Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭bonkey


    Or, if each name only occurs once, just use V1+V2+V3 with no SUM or GROUP BY.


Advertisement