Hi Guys,

I hope this will be an interesting and challenging problem for you.

I have an Access table of addresses with over 6000 records in it and for statistical purposes I need to select every 20th record.

I thought that I might run a query to select all the records in the tables and sort them by street and house number and save them in a new table. Then select from the second record to the twentieth record and delete them. Jump to and select the 22nd to the 40th record and delete them. Continue this throughout the table and this would produce roughly what I need.

Is this possible and can you tell me how to do it please?

Regards and thanks

Sebastian