Reference > Functions reference > Get functions > Get(RecordNumber)
 

Get(RecordNumber)

Returns a number representing a record’s position in the current found set.

Format 

Get ( RecordNumber )

Parameters 

None

Data type returned 

number

Originated in version 

6.0 or earlier

Description 

The value returned is determined by the relative place of the record in the found set, and it changes depending on the find criteria and the sort order.

Notes 

To return a value that uniquely and permanently identifies a record in this table, use the Get(RecordID) function.

Example 1 

Returns 3 when the current record is the third record in a found set.

For another example, see Get(ActiveRecordNumber).

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Get(ActiveRecordNumber) function