I now have, thanks to EE responses, a function that creates a random number. Now, I have a table with 13,000 or so record and what I need is for the random function to popluate one field in the table for each of the records with a random number. I tried an update query, but the process returned the same number. I assume because it was not looping. I think I need a recordset, but not sure how to approach this issue.
Public Function RandAccount() As Double
RandAccount = Format(Int(CDec((10000000000# * Rnd) + 1)), "0000000000")