>Try:
>Select $0 + sum(AMOUNT) as myamount ……
>
>
>>This is my code:
>>Select ,sum(AMOUNT) as myamount ……
>>My question is: I want myamount to be DATA TYPED as CURRENCY 8.4… any ideas?
------------
Hi Vlad...the currency is not working well. I will post aother question on the thread....thanks ...:)