Hello, again. I've been working on this access database for the last week or so. I've had a lot of learning experiences as this is my first one to do... I feel I've taken a lot of steps back and forth. But, I think I'm getting close! So, on to my question...
I have a form (frmJob) that the user inputs the job info, with piece parts of a job in a sub form, followed by steps per each piece part (process, assigned machine, Cycle time in days). This form transfers all this information into the 3 separate tables (tblJob, tblPart, tblSchedule). I made a query combining the wanted information to make a report labeled tblJob. What I'm working on now is, I want to add the cycle time days with the date started of the entire job and it will show estimated start time/estimated finish time of each step of the given piece part. I somewhat have it started in the report tblJob, but it won't accumulate the days on the estimated completion.
Any help would be much appreciated.
I have a form (frmJob) that the user inputs the job info, with piece parts of a job in a sub form, followed by steps per each piece part (process, assigned machine, Cycle time in days). This form transfers all this information into the 3 separate tables (tblJob, tblPart, tblSchedule). I made a query combining the wanted information to make a report labeled tblJob. What I'm working on now is, I want to add the cycle time days with the date started of the entire job and it will show estimated start time/estimated finish time of each step of the given piece part. I somewhat have it started in the report tblJob, but it won't accumulate the days on the estimated completion.
Any help would be much appreciated.
