Number sequencing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Grouped/Total query and I want to have a running count on each
record as they are generated in the query starting from a value from another
table, which is not included with the query at the moment.

I think that i have to subquery the value in from the other table but am
having some challenges.

as an example, it would be something like:

ID Field 1 Field 2
45 xxx xxxxx
46 xxx xxxx
47 xxx xxxx
48 xxx xxxx

Thank you for any assistance.
 
Dear Steven:

Do you want the running count to follow the ID values? Does the count run
starting from 1? Does it run sequentially for all the rows of the results,
or does it start over form 1 when a certain column changes.

Please post a query that gives everything but this running count, and I'll
add the code for the running count.

Tom Ellison
 
Back
Top