I need access2003 to generate a unique random number that is positive
and at least 6 digits in length
You don't say what the maximum length is, and whether leading zeroes
count toward the digits. Making assumptions, and applying some primary
school maths:
Largest number 8 digits = 99999999
Smallest number = 100000
Range = 99999999 - 100000 + 1 = 99900000
So we start with a number n: 0 <= n < 99900000
and then add on the 100000 to get back to the desired range:
n = Int(CDbl(99900000) * Rnd()) + 100000
Hope that helps
Tim F