I have a table and in the table detail section it will never have more than 12 rows;therefore, I want to have the numbers 1-12 listed sequentially on each row. For instance:
Row Data
1 record1
2 record2
3 record3
.............................through 12. Any help is greatly appreciated.
Thanks!
function to display the numbers 1-12 in detail of table
Pardha Saradhi K
You can use the RowNumber function: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_3quq.asp
Enter this expression in the detail textbox where you want the row number:
=RowNumber(Nothing)
-----------------------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
flwid