You did not told that 'AMOUNT' is currency ;)
Oh, well, currency type have more priority ;)
Use mton() function to convert field in query.
>>Select sum(AMOUNT)+ 000.0000 as myamount ……
>>
>>
>>>This is my code:
>>>Select ,sum(AMOUNT) as myamount ……
>>>My question is: I want myamount to be DATA TYPED as NUMBER 8.4… any ideas?
>-------------
>Vlad, that is not work.... my data type is still currency...maybe I did
>something wrong...:)))
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.