consecutive numbers in query

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hi,
I would like to produce consecutive record numbers in a query. The query
will be the source for a report. A record may not necessarily have the same
number every time the query runs, so numbering in a table wouldn't work.
Thanks for any help!
Jake
 
If I were you i'd do it on the report. On the On_Load set up a variable to
be = 1. Then set the unbound filed to be that value on the on_Current, and
increment ready for the next row.
 
If you want this for a report, the easiest way is to add a control to the
appropriate section of your report.

Set the control's properties as follows
Control Source: =1
Running Sum: OverAll (for one up number throughout the report) or Over Group if
you have a group and want to start over at one for each group.

That's all there is to it.
 
Thanks!!
John Spencer (MVP) said:
If you want this for a report, the easiest way is to add a control to the
appropriate section of your report.

Set the control's properties as follows
Control Source: =1
Running Sum: OverAll (for one up number throughout the report) or Over Group if
you have a group and want to start over at one for each group.

That's all there is to it.
Click to expand...
 
Back
Top