Counter

[JF Bouthillier]

Hi,

I am looking to have a counter in my dynamic query. I have a subroutine
incrementing a value but as soon as I scroll in the records, the values are
changing...

How can I make sure that a record stays with the same number (for the same
query execution)?

Thanks a lot.

 

[Allen Browne]

Simplest way to do this is to turn the query into an Append query, and add
the records to a table with an autonumber.

It is possible to use a subquery or DCount() expression to count the
preceeding records, but this is inefficent, unreliable if the filter/sort
changes, and impractical if there is not a simple and consistent way to
identify "preceeding records."