Sequence

[BingoGeorge]

Hi Folks, I am horrible with my "if" statements. I hope I can get some help.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]SEQ[/TD]
[TD]ID[/TD]
[TD]ETc[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]2000[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chicken[/TD]
[TD]2000[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]2001[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Onions[/TD]
[TD]2002[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]steak[/TD]
[TD]2002[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I need does it the SEQ numbers to do +1 if the ID shows 1 OR repeat the same SEQ is the number shows 2.

Let me know what you think.
Thanks

 

[63falcondude]

You're welcome. Glad we could help.