G
Guest
Hi all,
I have a field in my report which i want to format differently depending on
type of currency it shows (if it shows VND - then decimal places =0, if USD -
then decimal places =2)
somehow my code below doesnt work
it shows correct numbers but always formats them with decimal places = 2
can somebody help me please??
=IIf([VND]=True,(Format$(([BA-176-VND]*-1),"Standard",0)),(Format$(([BA-176-USD]*-1),"Standard",2)))
Thank you.
Lana
I have a field in my report which i want to format differently depending on
type of currency it shows (if it shows VND - then decimal places =0, if USD -
then decimal places =2)
somehow my code below doesnt work
it shows correct numbers but always formats them with decimal places = 2
can somebody help me please??
=IIf([VND]=True,(Format$(([BA-176-VND]*-1),"Standard",0)),(Format$(([BA-176-USD]*-1),"Standard",2)))
Thank you.
Lana