[AccessD] SQL Gurus - Running count.

Max Wanadoo max.wanadoo at gmail.com
Mon Jun 8 13:14:06 CDT 2009


Hi Guys,

With a select statement, how do I get a running count matching the rows
return.
Starting at 1 and incrementing by 1 for each row.
The final count to be equal to the number of rows returned.
The count to be part of the query.

I also want a second Count but this time not incremented.  Just a 1 in a
column for each row returned.

Thanks

Max






More information about the AccessD mailing list