[AccessD] Sequence number in query

Gustav Brock Gustav at cactus.dk
Tue Jan 24 04:26:29 CST 2006


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





More information about the AccessD mailing list