Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
UPDATE: I don't think this is going to work
May be this:
AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]
UPDATE: I don't think this is going to work
May be this:
AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]
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
May be this:
ProductName & AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]