Where do I get an access template for random generating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like a template in access or excel for random generating. ie. I need
to eat.... then a field would come up with the random generated answer from a
list i've put in. Thanks in advance
 
I would like a template in access or excel for random generating. ie. I need
to eat.... then a field would come up with the random generated answer from a
list i've put in. Thanks in advance
Click to expand...

Well, you don't need a *template* to do this, and you're not going to
find one!

Instead, you need a Query. Create a Query based on your list; set its
Top Values property to 1; and in a vacant Field cell type

Shuffle: Rnd([SomeFieldName])

where you use the name of some non-negative numeric field (such as a
sequential autonumber ID). Sort by this field (ascending or
descending, doesn't matter) and you'll get a randomly selected record.

John W. Vinson[MVP]
 
Back
Top