To retrieve the last updated Value

[JoeAcess]

hello everybody

I am building a small database using access 07. I have two tables tblIndent and tblreceived for a pharmacy program. Suppose i order for a medicine on a particular day say 100 qty. this order goes into the indent table .

Now when i receive the Medicines i enter that into the receiving table. Here i enter the received amount of tablets as a new record. Now my form should be able to add the received amount to the existing amount of medicine from the previous record. this is where i get stuck i am not able to update my current record based on my previous record or i am not able to pick the last value of the previous record of that particular tablet into the new record. Also this should be available in another table when called for.

can some one help me with the syntax or code to retrieve the last total amount of the Medicine

Thanks

 

[HiTechCoach]

See:

Inventory Control: Quantity on Hand

 

[JoeAcess]

thanks for that link... but the thing is it looks really complicated..
anything easier..

 

[stopher]

I reckon that's about as simple as it gets. All you have to do is sum up a list of transactions - that's it. You don't store the actual stock. You just calculate it when you need it.

Chris

 

[HiTechCoach]

thanks for that link... but the thing is it looks really complicated..
anything easier..

That is because Inventory control is very complicated. Trying to create software to manage inventory is one of the most difficult tasks in software development.