Negative Display

[jervin via AccessMonster.com]

Thanks for any help.
I have a form that views at a query, and there are some negative numbers
that are shown as -xxxxx in the form. Can I display as 0 for all the negative
value?

Thanks

 

[Guest]

Try something like
iif(nz(field1)<0,0,field1)

 

[jervin via AccessMonster.com]

thanks...

Try something like
iif(nz(field1)<0,0,field1)