Updating Group of Records with Random Number

[leadpro]

I need to update a group of records I query based on a select query. The field I need to update is [OrderNumber].

Preferrably, I'd like the field to update to the [SupplierID]"-"random and unique 5 digit number".

Remember, I need the same unique number for the group of records, not each record.

Thanks,

LeadPro

 

[gavjb]

for a simple solution you could try the RND function, something like cint(rnd * 20)