Generating a random ID on a form.

[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

 

[Golfinray]

Type functions on the help menu and look at the RND function. The syntax is
rnd([number you want to generate])