Where do I get an access template for random generating

[random generator's]

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

 

[John Vinson]

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

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]