Steven Mar
New member
- Local time
- Today, 10:44
- Joined
- Nov 13, 2021
- Messages
- 3
Good day
I have been battling to get something working for a while now, I am no expert and cant find a solution anywhere at this point.
I have only been using the Start Date and Defacto Start Date to get the dates, but if there is an early delivery or any delay then the dates are essentially inaccurate, and having to type in the information everyday for all the parts will take too long.
If you look at the attachment, you will see the table and query that I am using, it is just a mock up of what I am trying to achieve.
My goal is for the progression to follow one another, but they cannot overlap or cross.
Parts have to go through stages 1 - 10, each stage stage takes 3 days unless there is a hold up or a different paint layout used in stage 5 which makes it a 4 day stage.
The parts are supposed to arrive 3 days after the previous one, if not the start date will have the new date in - which allows for delays to be taken into account -
and every 3rd or 4th day all the parts effectively move one stage forward, where possible.
Keeping accurate dates is important especially when a customer wants an accurate delivery date. with the amount of parts passing through it is difficult to tell exactly. Especially when having to swap parts around for preference purposes, or delays for one part over another.
Having to swap out parts with another will also have to be taken into account, as delays are inevitable.
If I am looking at this the wrong way please let me know. I would love to get this working, the way I imagined.
I appreciate any response to this.
I have been battling to get something working for a while now, I am no expert and cant find a solution anywhere at this point.
I have only been using the Start Date and Defacto Start Date to get the dates, but if there is an early delivery or any delay then the dates are essentially inaccurate, and having to type in the information everyday for all the parts will take too long.
If you look at the attachment, you will see the table and query that I am using, it is just a mock up of what I am trying to achieve.
My goal is for the progression to follow one another, but they cannot overlap or cross.
Parts have to go through stages 1 - 10, each stage stage takes 3 days unless there is a hold up or a different paint layout used in stage 5 which makes it a 4 day stage.
The parts are supposed to arrive 3 days after the previous one, if not the start date will have the new date in - which allows for delays to be taken into account -
and every 3rd or 4th day all the parts effectively move one stage forward, where possible.
Keeping accurate dates is important especially when a customer wants an accurate delivery date. with the amount of parts passing through it is difficult to tell exactly. Especially when having to swap parts around for preference purposes, or delays for one part over another.
Having to swap out parts with another will also have to be taken into account, as delays are inevitable.
If I am looking at this the wrong way please let me know. I would love to get this working, the way I imagined.
I appreciate any response to this.