K
Kevin
Jim,
You would need a loop with a random number generator.
search VBA help for the rnd function. The give a formula
in that help description to bound the number generated.
Loop x number of times where x is the number of employees
needed. When the number is generated, insert it into a
temp table. I am not sure how your employee ids are
structured, if it is a simple integer id, this will work
directly. Some companies use a letter or series of letters
with a serial number. If that's what you do, you will have
to follow the randum number generator with a step where
you concantenate the letters onto the numbers.
After you have the employee IDs you will then have to run
a query to enter information into the used table. I would
expect all you would need here is the employee id.
Hope that helps!
Kevin
You would need a loop with a random number generator.
search VBA help for the rnd function. The give a formula
in that help description to bound the number generated.
Loop x number of times where x is the number of employees
needed. When the number is generated, insert it into a
temp table. I am not sure how your employee ids are
structured, if it is a simple integer id, this will work
directly. Some companies use a letter or series of letters
with a serial number. If that's what you do, you will have
to follow the randum number generator with a step where
you concantenate the letters onto the numbers.
After you have the employee IDs you will then have to run
a query to enter information into the used table. I would
expect all you would need here is the employee id.
Hope that helps!
Kevin