Sad Der
accessd666 at yahoo.com
Mon Dec 4 08:51:03 CST 2006
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.