I am trying to create a randomize function in access2007. I would like to run a query to return 100 rows from my table. I would like query to the table an get a different result set everytime i run the query. Help is needed. I am including the database i have started.