Some data was corrupted in my ARCUSFIL and I need to re-populate all of the aging information etc in that file. Will rebuilding the Customer file recalculate all the aging data? if not is there anther way. Or do I need to rebuild then Process: Recalculate Customer Account Balances and...
Instead of converting it to text, why not keep it as a number...
If int((((xx/10000)-truncate(xx/10000)) *10000) = 0 then crRED else crBLUE (where xx = your field)
This would be true for 12340000 but also 12340000.99865, if you want it to be false if it has a decimal then take away the Int...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.