Access to pull random records

[Guest]

I have access and have a several tables with about 4000 records each. I want
to pull records randomly from each database and create another table with the
information.

For instance I want to pull 200 records randomly from each table and make
another table with those records.

Is it possible to do this and if so how?

Thanks

 

[Douglas J. Steele]

See http://www.mvps.org/access/queries/qry0011.htm at "The Access Web"

 

[Guest]

Thanks Douglas:

I duuno if you can help me but I am not sure exactly how to work that code.
I placed the code inside a module and saved it. But then I am not sure of
what to do.

It says:
select top 100 mytable.*from mytable

I assume this means create a query and select the table I want to work on
and then click on the * to select all fields.

But then
where randomizer() = 0
order by rnd(isnull(mytable.question) * 0 + 1)

Where do I put those statements?

Any help appreciated.

 

[Douglas J. Steele]

Easiest way is to select the SQL View from the View menu. That'll show the
actual SQL that's being generated for your query. You can then type that in.

 

[ôë]

Easiest way is to select the SQL View from the View menu. That'll show the
actual SQL that's being generated for your query. You can then type that in.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



each.

 

[ôë]

Easiest way is to select the SQL View from the View menu. That'll show the
actual SQL that's being generated for your query. You can then type that in.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



each.