Random

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
Create another column. Make it an autonumber. Then you can use the Rnd()
function against this column.
 
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
 
Back
Top