[AccessD] Sequence number in query

Hi Rocky

It won't work for a select query you display and browse.
Don't know it that is your case.

How many records do you have?
Did you try out "my" SQL only trick? Not invented by me and not very fast but fast enough for small recordset and very reliable. And no reset code needed.

/gustav


>>> bchacc at san.rr.com 24-01-2006 02:14 >>>
Aha!  Thank you.  I thought there was something one could do in the 
query like the running sum trick but a function with a global should do 
nicely.

Thanks again

Rocky


Charlotte Foust wrote:
> Take a look at http://support.microsoft.com/?id=94397  "Adding Dynamic
> Counter to Query Count Records"
>
> Charlotte