>>I am running this code:
>>
>>
>>SELECT c_NationalityDetails
>>m.lnOldRecNo = RECNO()
>>
>>SUM nad_nonnationals, nad_nationals, nad_nonnationals + nad_nationals TO nSum1, nSum2, nSumTotal
>>
>>WAIT WINDOW TRANSFORM(nSum1) + " + " + TRANSFORM(nSum2) + " = " + TRANSFORM(nSumtotal)
>>
>>
>>I get the following displayed:
>>
>>64 + 4 = 9
>>
>>Does anyone have any idea why this could be happening?
>>
>>I've tried the sample code in the help on SUM and that displays correctly.
>>
>>I am stumped!
>
>Have you tried running SUM on each field individually to see the results?
>
>Tamar
Hi Tamar,
yes the 64, shows the result for the first field, 4 for the second, and 9 if I SUM nad_nonnationals + nad_nationals.