How to get current row number?

[#1]

Hi,

i have following tables:

Table 1

Category     Sub-Category    Title          FromCode     ToCode

ABC               xyz                      the title     0101               0101100

ABC               xyz1                    the title     0101               0101100

ABE               xyz2                    the title     0101               0101100

ABE               xyz3                    the title     0101               0101100

Table 2

Code               Value

0101               110.00

0101100        200.00

What i want to do!

- read range from table 1

- sum Value falling in the range

Challenge

From/To Codes are character string. Therefore, using rangesum seems not to be working on it.

Solution in Mind

to be able to get row number (in table 2) for From/To Code by looking up in table 2. Once, i get the row number than i can apply following expression:

Sum({$<RowNo ={">=$(=FromRowNo)<$(=ToRowNo)"}>}Value)

Problem

How to get the row no as per the above solution that i have in mind?

Thanks in advance,

Sibtain

[alexandros17]

When you load tab2 add a field using autonumber (look in help)

[#3]

I want to be able to get row no by looking up the code in the table 2. so that i could use that row no in Rangesum function to get the desired value.

Sibtain