Monday, March 12, 2012

function to display the numbers 1-12 in detail of table

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!

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.

|||Thanks. That worked!

No comments:

Post a Comment