Recent content by santoshuhg

If Group 101 has 20 items of inventory and 5 people in that Group, does that mean each person is allocated 20 or is allocated 4 units? Answer: if all 5 people in that group doesn't have nay existing inventory then yes 4 each would be the allocation. But if let say 5 people in group 101 has...

If you look into the code I have written under allocate button. This equally divide the inevntory group wise. Can you please add the above algorithm so that it include rollover count as well & then distribute equally

Hi Cronk Thanks for the input & I am on same page to calculate Can you help me with the code. Thanks in advance.

Sorry I posted accdb file... you can save in 2003 version and send ... else please let me know if I need to resubmit

Here is the file ... I have removed unnecessary data Allocated inventory is supplied with data. Main form - click Apply formats & it will pick rollovers from old inventory tables Allocate inventory take reference for CFR mapping tables & allocate inventory equally basis group numbers but...

Hi Mihail It's access 2010 file & the database is very heavy to zip & upload. I have numerous tables & queries out there... I am stuck only allocating inventory equally when rollover exists for an employee. The code I have written can allocate values equally but don't make the rollover...

Hi Can some one help me with the code to allocate inventory equally Inventory Table: Group Number - Work - Allocated To(Person Name) Reference Table: Group Number1 - Person1-Person2 - Person3 - Person4 Group Number2 - Person2-Person4 - Person5 - Person6 Group Number3 - Person1-Person3 -...