Bgilbert1102
New member
- Local time
- Today, 15:38
- Joined
- Oct 20, 2017
- Messages
- 7
Let me start out by saying my company has a non disclosure so I can not upload anything.
I am hoping I am just over complicating this (which I tend to do.)
Here's my issue. I have a query that pulls all the "loads" for that day with a description of the load and divides the pallets by zone in the warehouse. (Ex. Load 1 has 5 pallets in zone 1, 3 pallets in zone 2, and 2 pallets in zone 3. Although some loads have null values) As well as having a total number of pallets. (Load 1 has 10 pallets).
All the above is working. This is what I am stuck on.
I need to take the information it pulls in and have it randomly but evenly assign it to a user inputted amount of workers (due to call outs and vacations) based on zone and pallet count.
For example 100 pallets total between all loads. We have 4 workers that day each person gets 25 pallets.
Here is how the query looks. (Note: the zone with the highest number beneath islt is where the load is placed)
Load name Zone 1 zone 2. Zone 3. Total. Worker
Load Z. 2. 5. 3. 10. A
Load X. 8. "" 2. 10. A
Load Y. "" 5. "" 5. A
Load U. 25. "" "" 25. B
Load W. "" "" 25. 25. C
Load P. 13. "" 12. 25. D
Total for day. 100
Any help is greatly appreciated. Again I am missing the worker column in the above example. ("" = blank space)
Thanks ahead of time. And sorry for formatting issues I am on my phone.
I am hoping I am just over complicating this (which I tend to do.)
Here's my issue. I have a query that pulls all the "loads" for that day with a description of the load and divides the pallets by zone in the warehouse. (Ex. Load 1 has 5 pallets in zone 1, 3 pallets in zone 2, and 2 pallets in zone 3. Although some loads have null values) As well as having a total number of pallets. (Load 1 has 10 pallets).
All the above is working. This is what I am stuck on.
I need to take the information it pulls in and have it randomly but evenly assign it to a user inputted amount of workers (due to call outs and vacations) based on zone and pallet count.
For example 100 pallets total between all loads. We have 4 workers that day each person gets 25 pallets.
Here is how the query looks. (Note: the zone with the highest number beneath islt is where the load is placed)
Load name Zone 1 zone 2. Zone 3. Total. Worker
Load Z. 2. 5. 3. 10. A
Load X. 8. "" 2. 10. A
Load Y. "" 5. "" 5. A
Load U. 25. "" "" 25. B
Load W. "" "" 25. 25. C
Load P. 13. "" 12. 25. D
Total for day. 100
Any help is greatly appreciated. Again I am missing the worker column in the above example. ("" = blank space)
Thanks ahead of time. And sorry for formatting issues I am on my phone.
Last edited: