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

Stuart McLachlan stuart at lexacorp.com.pg
Mon Dec 4 08:44:08 CST 2006


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





More information about the AccessD mailing list