Calculated value in query

[programmingmiss]

i WANT TO CREATE A NEW POST ABOUT A CALCULATED FIELD IN QUERY, BUT i CANT LOCATE THAT....READ SIMILAR POSTS.

I WANT TO DO A SIMPLE THING ADD 2 VALUES (BOTH NUMBER TYPE) AND FROM SAME TABLE

IN DESIGN VIEW IN QUERY I DEFINED SUM: [VARIABLEA]+ [VARIABLEB], BUT i GET AN OVERFLOW ERROR, WHICH IS THINK IS A TYPE CLASH. CAN YOU ASSIST OR AT LEAST DIRECT ME TO WHERE I CANPOST ?. THX!!!

 

[CJ_London]

Sum is a reserved word so this is almost certainly the reason for your problem - suggest change it to Total or other word.

Here is a link to a list of reserved words

http://support.microsoft.com/kb/286335

 

[Pat Hartman]

You also need to be careful when doing arithmetic if any of the operands might be null. To handle nulls, you would use the Nz() function.

Nz([VARIABLEA], 0) + Nz([VARIABLEB], 0)