>Let's take it a step further,
>
>Suppose I have a select statement like:
>
>select (number*price) * iff(type = "BUY", 1, -1) as costs from TABLENAME
>
>
>It won't work with using:
>SELECT TRANSFORM(number*price, "999999.99") AS costs
>
>any other suggestions ?
>
>John

SELECT (number*price)*iif(type='BUY',1,-1)+000000.00 AS COSTS FROM tablename