Numbering Tickets

D

Dan Tschippert

I need a routine to put numbers on a ticket.

The numbers would be from 000 to 999. There would be 4 numbers on each
ticket and the same numbers would be repeated on the ticket stub.

Obviously the numbers can't repeat from 000 to 999.

Any suggestions?

Thanks, in advance.
 
D

Duke Carey

How do you determine what 4 numbers go on each ticket? Is it entirely
random, or is there some logic or sequence to it?
 
D

Dan Tschippert

The numbers are random on each ticket, but can not repeat through the 250
tickets (other than the two places on the ticket itself).
 
L

Larry Bud

Dan said:
I need a routine to put numbers on a ticket.

The numbers would be from 000 to 999. There would be 4 numbers on each
ticket and the same numbers would be repeated on the ticket stub.

Obviously the numbers can't repeat from 000 to 999.

Any suggestions?

Thanks, in advance.
Click to expand...

Create two columns, one with the numbers from 000 to 999, and the other
with the rand() function. Then sort by the column with the rand()
function. Every time you sort it, you'll get a different result.
 
Top