Previous & Current Records - one line

[learning_codes]

Hi,

I hope you can help to solve.

I have one line that has previous and current records. Some of the
records create starting current records but never had the previous
records.

If current and no previous record , i would like to see "First time"

If current and previous records but two different places from A move
to B - I would like to see "come in from A"

If current and prievous records but two different places from B move
to A - I would like to see "come in from B"

If current and previous records but move with one place C - I would
like to see "within one place - C"



I would appreciate your help if you provide me some samples.
Thanks

 

[KARL DEWEY]

You will need something in the records to know which is current and which is
previous record such as sequential numbering of the records. Alternately a
field like order number and shipping date that identifies the records as a
set and determines the sequence.
Does your data provide this kind of information?