Susan Harkins
ssharkins at setel.com
Mon Dec 4 09:04:59 CST 2006
If you just need the one field and the row count, a Totals query, choose the Count aggregate, would work, wouldn't it -- assuming the data field contained unique values. Susan H. No that did not do the trick. That would return: a 1 b 1 What i need is: a 1 b 2 ... ... z 26 Thnx anyway ----- Original Message ---- From: Stuart McLachlan <stuart at lexacorp.com.pg> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Monday, December 4, 2006 3:44:08 PM Subject: Re: [AccessD] ms-access variant of @@rowcount or rowcount On 4 Dec 2006 at 6:30, Sad Der wrote: > Hi, > > in my query i need a field with the rowcount. > > Let's say i've got a table (t1) with 1 field (Name). > This table has 2 values (a & b). > > I want a query that returns the field and a rowcount e.g.: > select name, row_count > from t1 > > Problem: what is the access variant for @@ROWCOUNT?? Count(*) ?-- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________ ________ Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006