jwcolby
jwcolby at colbyconsulting.com
Fri May 18 10:42:32 CDT 2007
My client specified "every other record". 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 Charlotte Foust Sent: Friday, May 18, 2007 11:26 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Select every nth record Since order is irrelevant, why not use the TOP 50 %? Are you trying to randomize? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, May 18, 2007 8:06 AM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com