code for random, 1 - 2 digit whole numbers:
just take tmp, and add it to a field in a current recordset (RS)Code:Dim tmp As Long
Randomize
tmp = Rnd() * 100
Debug.Print tmp
rs.fields("MyField").value = rs.fields("MyField").value & tmp
HTH
Tom
Printable View
code for random, 1 - 2 digit whole numbers:
just take tmp, and add it to a field in a current recordset (RS)Code:Dim tmp As Long
Randomize
tmp = Rnd() * 100
Debug.Print tmp
rs.fields("MyField").value = rs.fields("MyField").value & tmp
HTH
Tom
Is it possible to add a random number to the end of a field? If so what is the easiest way?
John