Great minds think alike…or share time in the gutter. J I did not see you solution when I posted mine. I have an application where I have had some issue with data types so I have been making sure they come out as intended which sometimes is different than what the computer thinks it should be. Javier, Javier Valencia, PE [email protected] O: 913-829-0888 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Monday, January 04, 2021 3:30 PM To: [email protected] Subject: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info UPDATE table SET column = ( (ROUND(column/50,0)) * 50 ) Breaks at ( 24 | 25 ), ( 74 | 75 ) ------ Original Message ------ From: "'Karen Tellef' via RBASE-L" <[email protected]> To: "[email protected]" <[email protected]> Sent: 1/4/2021 11:34:49 AM Subject: Re: [RBASE-L] - Rounding up/down - one more piece of info I won't be working with variables, this will be rounding up/down a column in a table Karen -----Original Message----- From: 'Karen Tellef' via RBASE-L <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Jan 4, 2021 1:33 pm Subject: [RBASE-L] - Rounding up/down Okay, which of you geniuses out there have a formula to do this for me?? I need to round an integer to the nearest 50 (up or down) IOW: 520 would be 500 570 would be 550 580 would be 600 Someone have a nifty formula to do that, or do I have to do 3 calculations: how far is each number from 500, how far from 550, how far from 600, and then take whichever is smaller? Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1654091038.1383109.1609788794870%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/1654091038.1383109.1609788794870%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1839463282.854096.1609788889964%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/1839463282.854096.1609788889964%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em3e1c5ea8-1640-4a00-bf34-dedbd51adc0b%40pathfinder <https://groups.google.com/d/msgid/rbase-l/em3e1c5ea8-1640-4a00-bf34-dedbd51adc0b%40pathfinder?utm_medium=email&utm_source=footer> .
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAM/LvoAhMdFDor3/aDIQKrEBAAAAAA%3D%3D%40vtgonline.com.
