|
|
You'll have to generate it elsewhere and update the table. If Access has
GUID columns (I don't think it does), one pretty easy way would be to take
the rightmost 5 characters of a GUID cast to a string. I think you're going
to be stuck doing it yourself, though. Or downloading a copy of SQL Server
Express... ;)
"Jason Cook" <jason@xxxxxxxxxxxx> wrote in message
news:fa580k$sl2$1@xxxxxxxxxxxxxxxxxxxxxxxx
> How do I generate a 5-digit alphanumeric code for each of the 500 records
> in my database and write those values into my new TheCode field (which is
> currently blank)?
>
|
|