Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL Question

  • 23-11-2007 3: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