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

Gustav Brock Gustav at cactus.dk
Mon Dec 4 09:06:01 CST 2006


Hi Sad

Look here:

http://databaseadvisors.com/mailman/htdig/accessd/2005-June/035324.html 

Generating a rownumber field in a query.

/gustav

>>> accessd666 at yahoo.com 04-12-2006 15:51 >>>
No that did not do the trick. That would return:
a 1
b 1

What i need is:
a 1
b 2
...
...
z 26





More information about the AccessD mailing list