It finally hit home!
There are NULL values causing the totals to go off. Not quite sure how some of the columns were working correctly, but at least it's working now.
>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!