Round up without using visual basic (equivalent to Roundup())

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to round up a value in a query to a multiple of 2: Example: 3.14 would
round up to 4, 4.001 would round up to 6. How do I do this using the round
function?
 
I'd suggest you divide by 2, use the round to get the next whole number and
double the answer.
 
FranklyItsFrank said:
I need to round up a value in a query to a multiple of 2: Example:
3.14 would round up to 4, 4.001 would round up to 6. How do I do this
using the round function?
Click to expand...

Is not clear for the criteria for roundish
Or better, J understand 3 to 4 but not 4 to 6

--
_ _
Ciao
MAssimiliano Amendola
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
MGFoster said:
2, 4, 6, 8 who do we appreciate....
Click to expand...
Interval of two units? ohhh
So
If Int(Yournum) < Yournum then YouNum = Int(YourNum)+2
--
_ _
Ciao
MAssimiliano Amendola
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Back
Top