Watch for your own mistakes.
>Vlad,
>
>It was a statement and incorrect one, not a sugestion .
>
>>As I said, it was just a suggestion. I did not seen any other reason for syntax error. In addition, did you tested this in old Fox Pro that is used in this thread? I'm interested also to know for sure.
>>
>>>>Hi!
>>>>
>>>>Yes, it is possible :) The problem not in the nested IIF().
>>>>
>>>>IIF(hank.pla_level = '1st', IIF(HANK.PLA_WITH = 'Ideal',ROUND(HANK.AMOUNT *
0.3,2), ROUND(hank.amount*
0.275,2)), ROUND(hank.amount*
0.5,2))
>>>>
>>>>Report engine just does not like values like ".5"
>>>>
>>>How did you came to such conclusion? The report engine works fine with values like ".5"
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.