The query I'm trying to build is to keep track of the length of a stave.
Let me explain the query:
- Bought length is applied only 1 time at the start of the record.
- First time I have to use the Bought length to calculate what is left
- Saw off length and sawing width gives the total piece sawed off for that order.
- That gives a new current length left of the stave which has to be used for the next order until the stave is at such length it isn't useable anymore.
The problem I bump into is that I can't seem to find a way to get the totals and to use the new current length for the next order.
Hope someone can help, I'm new to writing queries so any help is appreciated.
Let me explain the query:
- Bought length is applied only 1 time at the start of the record.
- First time I have to use the Bought length to calculate what is left
- Saw off length and sawing width gives the total piece sawed off for that order.
- That gives a new current length left of the stave which has to be used for the next order until the stave is at such length it isn't useable anymore.
The problem I bump into is that I can't seem to find a way to get the totals and to use the new current length for the next order.
Hope someone can help, I'm new to writing queries so any help is appreciated.