Adding values in two diff columns in ms access using sql query

sql ms-access ms-access-2003
Chaostryder picture Chaostryder · Jul 23, 2011 · Viewed 15.4k times · Source

Hey I was wondering you know how its possible to use "-" to subtract in the SELECT part of a query. So can you also use "+" to add? I've tried that and instead of adding the values together it does this 123+0.28=1230.28 does that maybe have anything to do with the number being in text format? But I hadn't ever changed format from when i used "-" and that worked . Thanks

my code :

INSERT INTO Table( Question, Calculation)

SELECT DISTINCT 'Addition' AS Question,(T2.Calculation + T1.Calculation) AS Calculation

FROM Some_Table T2, Some_Table T1

ORDER BY T2.Question;

Answer

Patrick87 picture Patrick87 · Jul 23, 2011

It might be interpreting + as string concatenation between a and b. Try "(a - 0) + (b - 0)" to force interpretation as numbers.

Related questions

how to use distinct in ms access

I have two tables. Task and Categories. TaskID is not a primary key as there are duplicate values.When there are multiple contacts are selected for a specific task,taskid and other details will be duplicated.I wrote the query: …

Read More
How to find duplicates from two tables and also to find duplicate in itself?

I have created this statement in access 2003 SELECT COUNT(*) FROM TABLEA WHERE NOT EXISTS(SELECT * FROM TABLEB); Does this statement helps to check if the records in table A is the same as table b? TABLEA is the new table …

Read More
inserting multiple rows with 1 query

I have problem in inserting multiple rows with 1 query using ms access 2003. When I use INSERT INTO like the code below INSERT INTO Employee values ('1','b','c'); INSERT INTO Employee values ('2','d','e'); the problem, ms …

Read More