Aug 22, 2005 #1 jlg5454 Technical User Jan 6, 2005 98 US Is there a formula example to assign 1 for every 10. For example if the field has a value of 11 than new value would be 1; 22 - 2; 100 - 10. Thanks for any assistance possible.
Is there a formula example to assign 1 for every 10. For example if the field has a value of 11 than new value would be 1; 22 - 2; 100 - 10. Thanks for any assistance possible.
Aug 22, 2005 #2 Remou Technical User Sep 30, 2002 13,030 BE Hi Maybe: [tt](i - (i Mod 10)) / 10[/tt] Upvote 0 Downvote
Aug 22, 2005 #3 PHV MIS Nov 8, 2002 53,708 FR Or simply [field] \ 10 Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886 Upvote 0 Downvote
Or simply [field] \ 10 Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
Aug 23, 2005 Thread starter #4 jlg5454 Technical User Jan 6, 2005 98 US Thanks for your tips. I'll try them out and let you know! Upvote 0 Downvote