Random Data Retrieval

[Rovers]

Hi,

Can someone please help. I am required to bring back a ranadom 10% of data where the [Total_Cost] field is less than £500.

Can this be done in one query? I have to use Access97 becuase this is the lowest Office Version we support.

.

 

[neileg]

Build a query that includes a calculated field that generates a random number and sort the query on that field. Use your £500 criterion on the Total_Cost field, and then change the query to a top Values query taking the top 10 random numbers.