Recent content by alex.rez

  1. A

    MS Access automatically assign the box number on the form

    Hi All!!! Thanks for help!!!:) I did it. I made it works by creating SQL query for each group. It is more complicated but i like it better it let me manipulate what box number I can start for each Group. On the form I use IF statement with DLookup (provided above) to look up box number and...
  2. A

    MS Access automatically assign the box number on the form

    No changes just ordered by group (see below) but I need put first 5 Quanta in box #1 other Quanta in the box #2, then first 5 Wistron in box #1 other Wistron in box #2. and do same with each different group. I think now to create separate SQL query for each group. ID Group GRBOXNUMBER 2...
  3. A

    MS Access automatically assign the box number on the form

    I removed red "AS" but still same issue. Actually I did not enter "AS" in the code some how it fixed by it self and when I saw it I left in as I know in other coding languages it works both ways for this function.
  4. A

    MS Access automatically assign the box number on the form

    Thank you very much for clarifications! Looks like I still need help. I created SQL query and it runs fine but looks like it just pack all different groups in the same boxes. It just count in order and when it reach 5 on the list (even those are different Groups it start new box#) Please see my...
  5. A

    MS Access automatically assign the box number on the form

    Thank you very much!!! now I see how things starts clearing out and it is really possible to accomplish this project. before I try still have couple questions: I am not too familiar with SQL on forms (I use SQL query for reports only and not many) How can I make it run with form when I...
  6. A

    MS Access automatically assign the box number on the form

    Thank you for quick replay. 1st: Yes, always 5. I may have other Group with qty-10 per box (example: A always -5, C always-10) but for same group always will be the same count. for starting point lets pretend all group always keep 5 per box. 2nd: We never run out of items and do not have to...
  7. A

    MS Access automatically assign the box number on the form

    Hello, Can someone help, please... I need in MS Access form automatically assign the box number for specific count of specific group name and increase the number when QTY reach the max. For packaging purpose. For example just need pack 5 items of specific group A in box # A1 and when it reach...
See more
Back
Top Bottom