General discussion
May 2, 2002 at 01:00 AM
audit

Access Query – Creating a Sample

by audit . Updated 24 years, 2 months ago

We have several queries that select a sample of records for us to review. We insert the random (rnd) function into a column and input the sample size we desire into the Top Values box on the Query Menu Bar. As we use the parameter query function extensively to pop up and ask for date value and the like, we have tried unsuccessfully to do the same with the Top Value. This means as the population varies and the statistical sample size we need changes, we have to open each query and change the Top Value and save the query and then run the report.

We want to incorporate these queries into a macro to faciliate the production of the sample reports created for each audit we perform. Is there a way to have the query ask for the sample size that goes into the Top Value box?

This discussion is locked

All Comments