C
colin
Hi
I hope someone can point me in the right direction.
I have a database that presents diarised items to individual users a set
number of items per working day and this differs between user.
eg user 1 has a maximum of 8 events to deal with per working day
If a check box is marked authorising an update then I want to find the
maximum diary date. Then append the checked items into the next weekday so
that there are only 2 items in each susequant working day.
EG
DiaryDate Day UniqueID Check Box
26/10/2007 Friday 1 TRUE
29/10/2007 Monday 2
30/10/2007 Tuesday 3 TRUE
31/10/2007 Wednesday 4 TRUE
01/11/2007 Thursday 5
02/11/2007 Friday 6
05/11/2007 Monday 7
02/11/2007 Tuesday 8
03/11/2007 Wednesday 9
27/11/2007 Tuesday 9999 Max Date
Updated To
29/10/2007 Monday 2
01/11/2007 Thursday 5
02/11/2007 Friday 6
05/11/2007 Monday 7
02/11/2007 Tuesday 8
03/11/2007 Wednesday 9
27/11/2007 Tuesday 9999
28/11/2007 Wednesday 1 TRUE
28/11/2007 Wednesday 3 TRUE
31/10/2007 Thursday 4 TRUE
Kind regards
Colin
I hope someone can point me in the right direction.
I have a database that presents diarised items to individual users a set
number of items per working day and this differs between user.
eg user 1 has a maximum of 8 events to deal with per working day
If a check box is marked authorising an update then I want to find the
maximum diary date. Then append the checked items into the next weekday so
that there are only 2 items in each susequant working day.
EG
DiaryDate Day UniqueID Check Box
26/10/2007 Friday 1 TRUE
29/10/2007 Monday 2
30/10/2007 Tuesday 3 TRUE
31/10/2007 Wednesday 4 TRUE
01/11/2007 Thursday 5
02/11/2007 Friday 6
05/11/2007 Monday 7
02/11/2007 Tuesday 8
03/11/2007 Wednesday 9
27/11/2007 Tuesday 9999 Max Date
Updated To
29/10/2007 Monday 2
01/11/2007 Thursday 5
02/11/2007 Friday 6
05/11/2007 Monday 7
02/11/2007 Tuesday 8
03/11/2007 Wednesday 9
27/11/2007 Tuesday 9999
28/11/2007 Wednesday 1 TRUE
28/11/2007 Wednesday 3 TRUE
31/10/2007 Thursday 4 TRUE
Kind regards
Colin