Random

[Brian]

hello all we have employee number that are actually text but what I need
to do is create a random selection of employees based on their EMPID.

so if I put in the text box 3 this I want

EMPID Name
1000 Jon Smith
1145 Jane Doe
1467 Bob Neil

To fill another table or record set so that they show up on a report

 

[[MVP] S.Clark]

Create another column. Make it an autonumber. Then you can use the Rnd()
function against this column.

 

[Michel Walsh]

Hi,


If EMPID always represent an integer, you can use it too:


SELECT TOP 3 *
FROM myTable
ORDER BY RND(INT(empid) )



Hoping it may help,
Vanderghast, Access MVP