SQL Query Help

[PaulSharma]

Hi, how can i add two numerical values in SQL query?

 

[RV]

How 'bout adding them up

column1 + column2

Or am I totally misinterpreting this one

RV

 

[jeremie_ingram]

Sorry, went vba there.

You can add them together easily. Use the query builder to see if you can get your results

TotForDis: [Field1] + [Field2]

and then switch to SQL view to see what it shows

SELECT Table1.Field1, Table1.Field2, [Field1]+[Field2] AS TotForDis
FROM Table1;

This sql adds field1 and field2 and the value is assigned to TotForDis