Assigning random numbers to customer numbers/index

[#1]

Hello,

I'm trying to assign random numbers to my customer numbers. 1st step was to index every customer number like this:
autonumber (sCustomerNumber)                                as [Customer Number]

The 2nd step is to assign each and every index with a number between 1-1000.

Can anyone share with me how to do this? 😃

Sincerely,

Betty Habtemariam

[sunny_talwar · Accepted solution]

UPDATE: I don't think this is going to work

May be this:

AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]

[#3]

Actually it did work, haha! Thank you! So I was wondering if you could answer another question too.

If I would like to assign a product name with a number anywhere between 1-1000, how would I do that without loosing the products' name? (I've tried to do that, but the products' name disappear and is replaced with the numbers).

Sincerely,

Betty Habtemariam

[sunny_talwar]

May be this:

ProductName & AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]