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

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??

Regards,

Sander


 
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com