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

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
 




More information about the AccessD mailing list