Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numbering Rows 1

Status
Not open for further replies.

AtlPayroll

Technical User
Dec 18, 2006
8
US
Is there a way to have a Derived Field sequentially number rows starting at a fixed number, such as 101, and increase by 1 for each row of data displayed?
 
Create a Derived field as such

rownum + 100

That will take the rownum of the output and add 100 so your first row will show 101 then 102 etc.

Hope that helps.
 

If you are using an SQLBase database then use this Macro Derived Field:

Sub row()
r=current() + 100
derivedfield r
End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top