Hi all

I think this has been ask before but I cannot find it.

When there are several records for the same spool number, I would like to display the spool number once until the next spool number and display this number only once until the next spool number appears.

The example does not display well once submitted.

Example

spoolnumber weld number welder id

sp1 1 K

sp1 2 R

sp1 3 A

sp2 1 C

sp2 2 K

sp2 3 A

would like the list view to resemble this:

spool number weld number welder id

sp1 1 K

2 r

3 A

sp2 1 C

2 K

3 A

thanks in advance

Lionel

Edited January 20, 200818 yr by Guest

Try an unstored calculation field =

Case ( SpoolNumber ≠ GetNthRecord ( SpoolNumber ; Get ( RecordNumber ) - 1 ) ; SpoolNumber )

Comment

Thanks for the information

Lionel

Michael

You are a bloody genius. thanks so much for the help.