[AccessD] Select every nth record

Thanks. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart
Sent: Friday, May 18, 2007 3:11 PM
To: accessd at databaseadvisors.com
Subject: Re: [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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com