Update Query - Random Alphanumeric String

[turkeylord]

Hi all! New here, hoping to learn and contribute where I can.




The problem I'm having is that I want to generate random strings to be updated into a field in a table.

I found a good alpha-numeric function I loaded into a module in my database. It generates a good string for me, but it puts the same string in every record, which doesn't do me any good.

Even when I try a simpler Rnd() function, it puts the same value in every record.

Any way around this?



Example output:

First Name	Last Name	Username	Email
Demo Internet	User	DUser1	H6RsCjLE@[our domain].com
Demo Internet	User	DUser2	H6RsCjLE@[our domain].com
Demo Internet	User	DUser3	H6RsCjLE@[our domain].com
Demo Internet	User	DUser4	H6RsCjLE@[our domain].com

A little background on exactly what I'm doing. A new system we're adding for our website requires a unique email address for each user - well, we have many user records whose emails are not unique in the table. The email address won't serve any functional purpose in the new system, so I was just going to load "[random]@[our domain].com".

Thanks in advance for any input you may have!

[orange]

You have to use the RANDOMIZE command to ensure different values.

[turkeylord]

Thank you for the reply! I added a Randomize statement to my function, but I still get the same value in every record. I must be doing something fundamentally wrong...

Apologies for the MSPaint collage, lol...

[turkeylord]

Solved by adding a seed argument for the Rnd() function, and sending an AutoNum.