Recent content by Bgilbert1102

  1. B

    Assigning text value based on numbers.

    Thank you looks good I'll give it at shot and report back
  2. B

    Assigning text value based on numbers.

    Mark... that is the basic break down yes . I need to assign operators to pallets. And have it be semi even. Like the example above. The reason for this we have workers not carrying their weight so we are dividing the work up evenly and distributing it. Since all loads have varying amounts of...
  3. B

    Assigning text value based on numbers.

    Easiest way i can think to say what I am trying to accomplish I have a set of random numbers that equals 100 10 20 15 10 20 5 5 15 How do I have access divde that number by a user inputted number for this sake we will say 4. Which is 25. Then assign A to 25 ,B to 25 ,C to 25 , and D to 25...
  4. B

    Assigning text value based on numbers.

    A zone is a section of the warehouse in relation to the items on that order. The only thing that happens when a truck contains loads for multiple zones in our forklift drivers have to travel different lengths. Basically without to much detail... 1 loads come in.. 2 workers verify the load...
  5. B

    Assigning text value based on numbers.

    We have loads delivered to us from hundreds of vendors, with several different appointments spaced about an hour apart, with varying amounts of pallets per load. Some loads have 1 pallet, some loads have 90 and everything in between. The different zones have different items in each, however, one...
  6. B

    Assigning text value based on numbers.

    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...
  7. B

    Hey

    Hey everyone my name is Brandon. I am fairly new to Microsoft access. I have built roughly 5 fully functioning databases. I game in my spare time and am currently learning java and VBA in my spare time as well. Looking forward to learning from everyone.
Back
Top Bottom