Tore,
thanks for your help but your suggestion does not always work.
In this case:
onzin = 100.01000
?IIF(onzin%1>0,onzin ,int(onzin ))
It returns 100.01000 and I wanted it to return 100.01
I have solved this issue by creating a function for it.
Thanks anyway for your help.
Regards,
Ron
>>In a report I need to print numbers with only the relevant decimals. 100.001 should print the same but 100.000 should only print as 100. Is there an easy way to do this or do I need to program this?
>>
>>Regards,
>>
>>Ron Brahma
>
IIF(yourval%1>0,yourval,int(yourval))