Number sequencing

[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.

 

[Tom Ellison]

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

 

[LeAnne]

Hi Steven,

See the MS Knowledge Base article "How to create a running totals query
in Microsoft Access" (http://support.microsoft.com/?kbid=290136). The
techniques described should work for DCount and most other domain
aggregate functions.

hth,

LeAnne