S
scubadiver
Hello,
I can insert a random number column into the query and shuffle it to select
the first row but I have 250,000 rows.
I want to do something (hopefully) simpler.
The query's first column contains a unique 6 digit code.
I would like to generate a random 6 digit code. The first three digits can
either be numeric (0-9) or alpha and the last three digits can only be
numeric (0-9).
It would great to press a button on a form to generate an ID. Can this be
done?
thanks
I can insert a random number column into the query and shuffle it to select
the first row but I have 250,000 rows.
I want to do something (hopefully) simpler.
The query's first column contains a unique 6 digit code.
I would like to generate a random 6 digit code. The first three digits can
either be numeric (0-9) or alpha and the last three digits can only be
numeric (0-9).
It would great to press a button on a form to generate an ID. Can this be
done?
thanks