I need to select a certain number of records at random from one table and insert them in another. For example, if there are 1000 records in the first table, I want to select 100 of them at random and insert them in another table. I can't think of a way to do this in a query, don't know if it's possible. I'm thinking it could be done via a loop in code, but can it be done directly in a query? Thanks.