[AccessD] ms-access variant of @@rowcount or rowcount

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.



More information about the AccessD mailing list