RANDBETWEEN like function in Access calculated query field (1 Viewer)

[world33]

Hello,

Is there any module, function, expression or other way to mimic an Excel RANDBETWEEN function in a MS Access calculated query field?
I read that it is possible to use Excel functions in Access but my level is too basic to be able to apply that option.
I am looking for a query expression that allows me to randomly choose a text value. For example:
RANDBETWEEN(Founded in, Established in) or RANDBETWEEN(located in, situated in, etc.).
Any idea or workaround to achieve that?

Thanks for any help.

world33

 

[June7]

Access VBA has RND function which returns a random number. It can be used in query or VBA. Use it in conjunction with RANDOMIZE function in VBA.

 

[world33]

Access VBA has RND function which returns a random number. Use it in conjunction with RANDOMIZE function.

Emulating the Excel RANDBETWEEN function will involve writing custom function in VBA.

Thanks. How Do I combine them to generate random text?

 

[June7]

Apparently I edited my previous post after you read it.

What kind of text do you want - a single character?

 

[arnelgp]

somewhere i get this:

Public Function RandBetween(Optional Lowest As Long = 1, Optional Highest As Long = 9999)
' Generates a random whole number within a given range
   Randomize (Timer)
   RandomNumber = Int(Rnd * (Highest + 1 - Lowest)) + Lowest
End Function

you can only pass numeric value.
use PK field and Dlookup() its value to generate
a Random String.