John W. Colby
jwcolby at colbyconsulting.com
Thu Nov 11 10:11:07 CST 2004
Count(PK) as Cnt in the select clause Where PK is the primary key John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, Mark Sent: Thursday, November 11, 2004 10:40 AM To: [AccessD] Subject: [AccessD] Query - Add Recordcount Field Group, Someone has this at the top of their head or near their fingertips...hopefully. In a query, what is the syntax to add a running recordcount column? Thanks. Mark -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com