Random records

[Manton]

Access 2000.
I have a field in a table (tbl_data entry) which has a field called Free and
another field called SD (containing 2 options: 5 and 6)
The Free field is a yes/no format.
I'd like to run a query which upon entering a date range ("Enquiry Date")
value -allows the query to choose 170 records (by ticking off the yes/no
field "Free") randomly from tbl_data entry.
Alternatively: It could choose (ticking off the yes/no field "Free) the
first 170 records within the date range entered (choosing the earliest date
and working down the list).
thanks.

 

[John Vinson]

Use TOP n

To use it your query must be in SQL view.

.... or you can view the query's Properties and set the Top Values
property there.

 

[Larry Daugherty]

Use TOP n

To use it your query must be in SQL view.

HTH