John Eget
joeget at vgernet.net
Thu Apr 8 18:43:42 CDT 2004
The problem is when the 10th thru the 15th record are the same values all of them show up! ----- Original Message ----- From: "Dave Sharpe" <DaveSharpe2 at cox.net> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, April 08, 2004 6:18 PM Subject: Re: [AccessD] cumulative record count question > 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 > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >