Doug Murphy
dw-murphy at cox.net
Mon Aug 8 11:02:41 CDT 2011
Don't know. I am more of an empirical developer. I'd try it. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Wil Wakely Sent: Sunday, August 07, 2011 8:06 PM To: sql-dba Subject: [dba-SQLServer] Delete Is this a correct sql statement to delete the first 5 rows (oldest dates) of a recordset for Access 2002? I'm new to SQL. strSQL1 = "DELETE FROM rs WHERE TOP 5, player=1 ORDER BY playdate ASC;" DoCmd.RunSQL strSQL1 ==wilw -- ===wil wakely sunny san diego ca _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com