[AccessD] Select every nth record

If it is SQL Server 2005, check the RowNumber() function.
And combine it with the Access mod function.

At 10:35 AM 5/18/2007, you wrote:
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Select every nth record
>
>Is there a SQL statement that will do this directly?  I have a table of
>40K records and I want to split it into two tables, each containing
>every other record of the 40K record table.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com