In my table, every Job (row) will have maximum 10 activities to perform, in some jobs only 5 activities only performed. For every job which activities to perform will be defined a supervisor using a form and it will be stored in the table. ( i used check box)
In my table i have the fields for all the 10 activities and every activity got date completed field also, and the last field is Signoff date for the entire job (row). Here i want access to verify for every job(row) which are the the activities assigned and if the corresponding activities got the dates updated, then i want to update the last activity completed date in the signoff date field in the table.
to make it clear to help me, If for Job1 ( row1) is assigned to 5 activites out of 10, i want access to verify which are five activities are assigned and its corresponding date completed field and to display the last activity completed date in the signoff date. If only 4 activities completed and 5th one is pending then the signoff date should be empty.
please help me...i m in the final stage of finishing mt database:banghead:
In my table i have the fields for all the 10 activities and every activity got date completed field also, and the last field is Signoff date for the entire job (row). Here i want access to verify for every job(row) which are the the activities assigned and if the corresponding activities got the dates updated, then i want to update the last activity completed date in the signoff date field in the table.
to make it clear to help me, If for Job1 ( row1) is assigned to 5 activites out of 10, i want access to verify which are five activities are assigned and its corresponding date completed field and to display the last activity completed date in the signoff date. If only 4 activities completed and 5th one is pending then the signoff date should be empty.
please help me...i m in the final stage of finishing mt database:banghead:
