This is a migrated thread and some comments may be shown as answers.

auto increase number in a column

0 Answers 128 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
sf
Top achievements
Rank 1
sf asked on 20 May 2010, 02:30 AM
in my report detail section I have a list of items. I want to put in an auto increase number in front of each item. Is it possible? e.g.
1    John Smith    Doctor
2    Mark Williams    Teacher
3    Joe Smith    Scientist

I dont want to do this in my query because the query has complex grouping.

found the function RowNumber()

never mind, thanks for reading

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
sf
Top achievements
Rank 1
Share this question
or