I have a table that will be sorted descending by a number field. I want to apply another column that will contain sequential number starting with 1. Something like this:
DATA_COL _number
25 1
20 2
10 3
2 4
1 5
I have tried DCOUNT but am having a hard time with syntax.
DATA_COL _number
25 1
20 2
10 3
2 4
1 5
I have tried DCOUNT but am having a hard time with syntax.