How do I get a query to add an incrementally increasing number?

  • Thread starter Thread starter RNDL
  • Start date Start date
R

RNDL

I have a query that selects a subset of records. I need to add a "run
number" to that subset, starting with 100. That is, the first record is 100,
the second 101, etc. I know there has to be a way to do this, but I can't
figure it out
 
RNDL said:
I have a query that selects a subset of records.
I need to add a "run number" to that subset, starting
with 100. That is, the first record is 100, the second
101, etc. I know there has to be a way to do this,
but I can't figure it out.
Click to expand...

If you only need to display this number in a report, you can add a Control
to the Report with a Control Source of = 1 and set its Running Sum to the
appropriate setting of "Over Group" or "Over All". Add that value to 100 and
it will give you the number. If you need it for other purposes, then you've
had other good advice.

On the other hand, it can be helpful if you explain _what_ you want to
accomplish rather than _how_ you think it should be accomplished, and you
might get some useful alternative suggestions.

Larry Linson
Microsoft Office Access MVP
 
Back
Top