>>>Iif( Mod(NUMBER_TO_REACH,1000) = 0, 1, Mod(Mod(NUMBER_TO_REACH, 1000 ),11 ) )
>>
>>I'm not sure, need to think. For 100, it's 1, for 200 it's 2, for 300 it's 3, etc.
>
>I think at after 1000 it starts all over again back at 1 again.
Right, but we assumed, that number should be round, e.g. 100, 200, 300. What if it's any integer number greater than 10?
If it's not broken, fix it until it is.
My Blog