SQL Question

danindublin

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

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

bonkey

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