Do I have any function similar to randbetween() function of Excel in MS Access?
F Fresh Access user Dec 27, 2008 #1 Do I have any function similar to randbetween() function of Excel in MS Access?
S Stuart McCall Dec 27, 2008 #2 Fresh Access user said: Do I have any function similar to randbetween() function of Excel in MS Access? Click to expand... You can roll your own using the Rnd function: Function randbetween(lower As Integer, upper As Integer) As Integer Randomize randbetween = Int((upper - lower + 1) * Rnd + lower) End Function
Fresh Access user said: Do I have any function similar to randbetween() function of Excel in MS Access? Click to expand... You can roll your own using the Rnd function: Function randbetween(lower As Integer, upper As Integer) As Integer Randomize randbetween = Int((upper - lower + 1) * Rnd + lower) End Function
