[AccessD] cumulative record count question

John,

    You could see my sample db named  RunningCountSum_2K  at Rogers Access Library (other developers section) at the following link -
    http://www.rogersaccesslibrary.com

    The underlying approach could be adapted suitably for your specific needs.

Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: John Eget 
  To: Access Developers discussion and problem solving 
  Sent: Friday, April 09, 2004 05:13
  Subject: Re: [AccessD] cumulative record count question


  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