R
Ranjith Kurian
I have a table called as Task; this table has four columns Name, Task,
Frequency and Week.
Name: employee name
Task: Assigned work to each employee
Frequency and Week: the due day to perform the assigned task
I would like to create a Form, when the Name is selected in a combo box and
if any task is pending on that particular day it should be viewed
For example: if today is Monday then if I select Name OP , in his list the
pending task should be shown as B.
Frequency column:
Daily: if I have mentioned daily for any task then it should be viewed on
everyday as pending task.
If it’s weekly then every week it should be viewed as pending,
simultaneously it should check Week column to know which day of the week it
should be pending
Name Task Frequency Week
OP A Daily Daily
OP B Weekly Monday
OP C Weekly Thursday
OM D Weekly Friday
OM E Weekly Wednesday
OM F Monthly 2nd Week of everymonth(1stday)
OX G Monthly every 1st day of the month
OX H Quartely 3rd month 1st day
OX I Quartely 3rd month 15th day
Frequency and Week.
Name: employee name
Task: Assigned work to each employee
Frequency and Week: the due day to perform the assigned task
I would like to create a Form, when the Name is selected in a combo box and
if any task is pending on that particular day it should be viewed
For example: if today is Monday then if I select Name OP , in his list the
pending task should be shown as B.
Frequency column:
Daily: if I have mentioned daily for any task then it should be viewed on
everyday as pending task.
If it’s weekly then every week it should be viewed as pending,
simultaneously it should check Week column to know which day of the week it
should be pending
Name Task Frequency Week
OP A Daily Daily
OP B Weekly Monday
OP C Weekly Thursday
OM D Weekly Friday
OM E Weekly Wednesday
OM F Monthly 2nd Week of everymonth(1stday)
OX G Monthly every 1st day of the month
OX H Quartely 3rd month 1st day
OX I Quartely 3rd month 15th day