seekinganswers
Technical User
After much trial and error, I managed to get the data I wanted by using the following Iif statement
=IIf([TotBidAmts]=0,"No Bid",[TotBidAmts]).
But, I need those TotBidAmts not = zero to appear in currency format. Possible?
=IIf([TotBidAmts]=0,"No Bid",[TotBidAmts]).
But, I need those TotBidAmts not = zero to appear in currency format. Possible?