It works. Thx.

In fact, I just multiply by 1 at both the SELECT and it works. Any reason for multiplying and dividing the big number. It seems to make the field big.


Tai SC

>>I am using FPW26. I am trying to UNION two select statement. The SELECT statement looks like the following:
>>
>>SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) AS problem;
>> from a, b ;
>> where a,doc=b.doc ;
>>UNION ;
>>SELECT a.doc, doc_date, doc_amt ;
>> from a ;
>> where .......
>>
>>
>>Anybody can tell me how I can force the SUM() type to be the Numeric size I want. apply is N(9,2). discount is N(7,2), miscellaneous is N(7,2), problem ended up as N(16,2) and my doc_amt is N(9,2). How to force problem to be N(9,2)?
>>
>>
>>Tai SC
>
>You are so right this silly behaviour. A silly but working suggestion is here :
>SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) * 1000000.00/1000000.00 AS problem;
> from a, b ;
> where a,doc=b.doc ;
>UNION ;
>SELECT a.doc, doc_date, doc_amt* 1000000.00/1000000.00 ;
> from a ;
> where .......
>
>Cetin