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 ;
SELECT a.doc, doc_date, doc_amt ;
from a ;
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)?