For those of you who read the previous post:
I've moved forward a bit, and now need what *should be* a relatively simple question answered.

How do I request a specific record from a particular field randomly?

I.E. Say I wish to pull a random record from table A, Field 1, where field 1 has 50 records.

I thought perhaps utilizing the Int(Rnd * #)+1 process would work for this, (Where the Int is used to pull a record by ID#/Field) but as it turns out, I can't seem to find any reference material to tell me what I need to use to accomplish this. Does anyone of you folks have an idea?

(Further - If I perhaps wanted to choose a random record from a random field, what process would I use to do this? (Say I wanted to pull a random record 1-50, from random Field 1-3, on Table "Example")

(Further further - From Random Table A-C?)

Any help would be appreciated. (I now understand the basics of database accessing)

You could put the records into an array (there is a recordset function for this), and use a random number—limited to the array bounds—to select the record out of the array.

Additionally, having done this, the array is multi-dimensional, having an element per field (column). You can perform the same operation to randomly select amongst the array of fields which is to be found at each 'node' of the array of records.

"A random record from a random field"? Sorry, I do not get it. A "record" is a collections of "fields", and not viceversa.
So you have a table "Example". Open the table and get the total number of records. Generate a random number as Fix(rnd * NumberOfRecords). Move to that record (how to do it depends on the database) and read it.
If you need to extract a random field from that record, do the same using the recordSet.Fields collection
To Brian: your suggestion is not feasible for tables with lots and lots of records, you cannot just put all of them in a memory array.
Marco