Previous & Current Records - one line

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

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
 
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?
 
Back
Top