Adding random numbers to acrostic

[bumi]

I am trying to create an acrostic with the following
elements: abstractor code, location code and 6 digit
random number.
I have the following:
Acrostic= [AbstractorCode] & [LocationCode] &
[?6 digit Random#]

 

[Jonathan]

-----Original Message-----
I am trying to create an acrostic with the following
elements: abstractor code, location code and 6 digit
random number.
I have the following:
Acrostic= [AbstractorCode] & [LocationCode] &
[?6 digit Random#]
.

Hi Bumi,
your post is not clear about the question that you have. I
am assuming that you want to know how to calculate a
random number.

Use the following as an example.

Dim MyValue
MyValue = Int((1000000 * Rnd) + 100000) ' Generate
random value between 100000 and 1000000

Luck
Jonathan