Dave Sharpe
DaveSharpe2 at cox.net
Thu Apr 8 17:18:35 CDT 2004
John try SELECT TOP 10 * from tblProgram Dave ----- Original Message ----- From: "John Eget" <joeget at vgernet.net> To: <AccessD at databaseadvisors.com> Sent: Thursday, April 08, 2004 5:00 PM Subject: [AccessD] cumulative record count question I am performing a query on a table and only want to display ten records from the query. Does anyone know how to do a running sum of record count of a table .the table contains program....sumofRecord nothing more and the table name is tblProgram. I want to do this in a row or the query Thanks John -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com