random number generator

[scottdg]

I don't need to use up all 70 numbers first. It is okay if I run it and get:



2, 23, 45, 67, 14, 7, 70, 55, 13, 37
then the next time (or two or three times down the line)
4, 65, 17, 63, 52, 23, 29, 41, 62, 19

I will review what you sent and see if I can get any ideas.

Thanks,
Scott

[orange]

Ok. It still isn't clear exactly what you want. You said unique - no repeats - so 1 or 2 repeats seems acceptable??

My article on selecting N random numbers should be a starting point to give what you need. Just use Top 10 -- not percent.

[scottdg]

sorry - repost

[scottdg]

When I say repeats I mean of the 10 number selected each can only be selected once.

2, 23, 45, 67, 14, 7, 70, 55, 13, 37 is acceptable
2, 23, 45, 67, 14, 7, 23, 55, 13, 37 is not acceptable

[orange]

OK, i read your previous example incorrectly. I thought both lines were acceptable --ok so you have it working.
Good stuff.

[scottdg]

No - still producing the unacceptable results (7 out of last ten times). I was not able to use any of the examples to get it working properly.

I am better at reading code at this point then I am writing it so it could be me.

[orange]

Did you copy and paste the function and test routine I provided?

You can adjust the code to work with different ranges.

Can you post the code you are using that is giving you problems?

[orange]

I am attaching a sample database.
I tried to mock-up your situation by setting up table with 2 fields recordid and xtrafield.
RecordId simulates your recordid (record identifier) and
xtrafield is where I record a random number.

I created the table, then populated it with routine MakeRecords in module1.
I then ran routine dgScottStuff in module1. This routine populates or repopulates the value in xtrafield with a random number.

Query, QueryToGetRandomRecords with sql

SELECT SubQuery.recordID
FROM (
    SELECT TOP 10 tblSampleRecords.RecordID
        ,tblSampleRecords.xtrafield
    FROM tblSampleRecords
    GROUP BY tblSampleRecords.RecordID
        ,tblSampleRecords.xtrafield
    ORDER BY tblSampleRecords.xtrafield
    ) AS SubQuery
ORDER BY SubQuery.recordID;

Selects 10 random records from the table.

You can repopulate the xtrafield by running dgScottStuff at any time. This will assign different(very high probability) random numbers to xtrafield, and the select top 10 would result in a different set of records (with some probability of repeats).

Good luck