Update a record and input random numbers 1

[jliz2803]

Is there a way to write an update query that will update all records with random values. I want the input mask to be ??1?8?5? with the ? being equal to a random value and the 1, 8, and 5 being static values in those same positions.

 

[PHV]

Have a look at the Rnd and Mid functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jliz2803]

I tried to give you more stars but they only let me giv eyou one that mid function combined with the random function to select the start position is awesome, Thanks so much.