Hello all, I'm continuing to work on a task driven/work-flow type database. Basically, I'm tracking parts. There are several time sensitive tasks that needs to happen to each part within a given timeframe. The entire database is being designed to track when tasks are completed sending out notices when the task is not completed by the due date.
All my tasks and due dates fields are located in one table, Tasktbl. My form's record source is a query from my Tasktbl and Partstbl. I am using the DateAdd function in my query to calculate my due date field. There is another field where the user will place the actual date the task was completed. For example, I have a field called Rec_Datedue (populated through DateAdd), another field is called Rec_Datecomp (which is the manual input field of when that task was actually completed).
The dates in my query are being calculated as planned but I've run into a dilemma. The value of the DateAdd is not being transferred to the Tasktbl but remains visible on the form only. I think I need the value to be in the table so that I can complete the next, and final, step which is to send out emails to all who missed the due date. All the examples I've seen uses the two dates in a table i.e., received date and due date, to write code for auto emails to be sent. Do I need to have the value of DateAdd to be in the table? Or, will the value of the DateAdd field on the form be sufficient? Thanks