If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Week, monthly, quarterly
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 |
Thread Tools | |
Display Modes | |
|
|