Help with Rank

[Brad1]

I've got some SQL that is returning a Rank - sort of.  It ranks the data and then repeats when the larger group changes.

Example:

1

2

3

4

4

4

7

8

8

10

1

2

3

4

5

5

7

...

I'm not sure why my SQL is doing that.  It's not my SQL for one thing and it's fairly complex.  How can I use - maybe - a Multi-Row Formula Tool (or some other tool) to look at the row before and if the same number then add 1?

Thanks in advance for any help.

[rarmstrong · Accepted solution]

Using the Multi-Row Formula tool, select "update existing field" and use this formula:

IF [Field1] = [Row-1:Field1]
THEN [Field1] + 1
ELSE [Field1]
ENDIF

Replace [Field1] with the name of your field

[Brad1 · Accepted solution]

Never mind.  I got it.

[Brad1]

I like yours better.  Thx