Hi Donald
An SQL query will always bring in the column definition correctly, so there are two possibilities. Either you are not selecting the right column; you said it is named 'account' but the query you show is accessing 'SUM(tranAmt)'
or you are accessing the wrong table where the column is actually defined as N(10,2)
>Query:
> SELECT ;
> Client, ;
> TranCred AS AcctNumb, ;
> SUM( TranAmt ) AS SubTotl ;
> FROM Transact ;
> WHERE Client = 1 ;
> AND BETWEEN( TranDate, {01/01/80}, DATE() ) ;
> AND TranCred > 0 ;
> GROUP BY Client, AcctNumb ;
> ORDER BY AcctNumb
>
>Any one know what gives? I need the third decimal place in the result set.
----
Regards
Andy Kramek