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?
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