Hello,
I have a table where each Volunteer start from Day 1 to n...(Sequence)for example:
Volunteer | Day
1 | 1
1 | 2
1 | 3
1 | 4
2 | 1
2 | 2
2 | 3
3 | 1
3 | 2
I am hoping if somone could help, i want to be able to loop through a Volunteer' Day, to find missing sequence. eg. the user specify which Volunteer they want to see (using Textbox) then it will bring up just that volunteer and the missing their sequence:
Volunteer | Day | Error
1 1 ok
1 2 ok
1 4 Error
1 5 ok
If possible output it in a datasheet (table).
Thankyou in advance