SQL Question

danindublin · 23-11-2007 03:00PM #1

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 · 23-11-2007 03:51PM

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 · 23-11-2007 04:08PM

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

SQL Question

Comments