Wil Wakely
wilw31 at gmail.com
Sun Aug 7 22:06:23 CDT 2011
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