Row Counter in Report and/or Query

[Bart Steur]

Hello,

I want to add a row number to my report and/or query.

Lets say my query/report contains 9 rows. Now I want a column in front of it
containing the numbers 1 to 9

IE:

# Salesman Last Sale Amount
1 Name1 Date 30492
2 Name2 Date 30291
3 Name3 Date 40392
4 Name4 Date 64343
5 Name5 Date 12342
6 Name6 Date 70296
7 Name7 Date 30892
8 Name8 Date 56684
9 Name9 Date 97784

The number is not in the source table.

Thx
Bart

 

[Duane Hookom]

Do this in your report. Add a text box:

Control Source: =1
Running Sum: Over All