[AccessD] cumulative record count question

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
>





More information about the AccessD mailing list