Numbering Tickets

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.

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

"Dan Tschippert" wrote:

> 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.
>
>
>

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


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:F7A5D75E-F5A6-4F2F-8AF9-4216FA50660F@microsoft.com...
> How do you determine what 4 numbers go on each ticket? Is it entirely
> random, or is there some logic or sequence to it?
>
> "Dan Tschippert" wrote:
>
>> 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.
>>
>>
>>

Dan Tschippert wrote:
> 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.

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.