Random Pin Numers

[Makis]

Hello all.



First of all I want to say that my experiense in Access is very little.
I want to create a database with

Random generated numbers that starts with 3 specific digits and continues with 7 or more random digits.
Exampe 309.1234567

Every number must be unique (only the second part - the 7 digits one).
Also, I must have a report anout these numbers. I may have 5 different groups (one starting with 309 the second 310 thrird 311 etc) and a function that I can check where a specific pin is located (in which group) and mark it as used or not.

Is this possible?

Thank you in advanced.

[ItsMe]

...
Is this possible?

Sure. You should probably start with mastering the random function. Here is an example.

Dim intMyRandom As Integer
Dim intOriginalNum As Integer

intOriginalNum = 9
        Randomize
        intMyRandom = (intOriginalNum * Rnd) + 1
        MsgBox intMyRandom

You should probably generate a random for each of the 7 digits and then concatenate as a string. You could then compare to an existing recordset using something like DAO to ensure non-duplicating numbers.

[ranman256]

Build a keyed table so you dont get duplicates..then run a query to append the function RND(7)
to get your randoms.

[ItsMe]

... the function RND(7)...

What does that do? Is that parameter to provide a 7 digit result?

[ranman256]

It builds the 7 digits of un-duplicated pins.

[ItsMe]

It builds the 7 digits of un-duplicated pins.

Interesting. I am not seeing how to consistently return 7 digits. Perhaps you can show an example.

[ranman256]

INSERT INTO tPINs ( Num ) SELECT Rnd(7) AS Expr1;

[ItsMe]

INSERT INTO tPINs ( Num ) SELECT Rnd(7) AS Expr1;

I do not see that as a solution considering the business rule of 7 or more digits.