Column containing sequential numbers

[Hunter]

I want to add a column to a report. The column is to contain a simple numbering of the records as they appear on the report (1,2,3,...). Is there a way to do this using a calculated field in the query the report is based on?

 

[Rich]

You don't need to add to the query just add an unbound textbox to the detail section of your report set control source to =1 set running sum over group.
HTH

 

[Hunter]

Thanks! That was too easy!