[AccessD] cumulative record count question

You'll need an extra field in your ORDER BY clause

SELECT TOP 10 fldlist
FROM tblProgram
ORDER BY field1, field2

To break the duplicate tie. 

Susan H. 


The problem is when the 10th thru the 15th record are the same values all of
them show up!


> 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
>


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com