Leo_Polla_Psemata
Registered User.
- Local time
- Today, 07:56
- Joined
- Mar 24, 2014
- Messages
- 364
Hi
The above is a draft of my table.
There are records and dates that the event happen for each record.
If one record has been sitting idle in one event for too many days, this needs extra attention because it must be some business errors or bad service.
In the last field "status", I need to set a status for each record.
If last event is event1 (date is the date this record arrived at event 1) then status is A
If last event is "event 2" at this date, then status is B
If last event is "event 2" but for some reason date on "event 1" is missing, this is error.
And so on.
The code must check which is the last date and update the correct "status" of each record.
If i use the code based on "if , case is " , it will take too long and too many lines to complete the code.
Is there any other method I could make it easier?