Another Access SQL Question

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@gcstulsa.com> wrote in message
news:fa580k$sl2$1@forums.macromedia.com...
> 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)?
>