How To Use Previous Record For calculation

[Sandip]

Hi
My problem is i am making one simple application for Inventory
I need to know how can i use previous records data for calculation
Example I have received 10 units on 1/1/03 and used 5 on 1/1/03
next day i have received 7 units and used 2 units so my balance stock will be 10-5+7-2 = 10 so how to get this
Also if i am using any parameter for this how it will take care for next record Example If at the end of January-03 month i have 7 units Balance and if i am retriving data only for Feb-03 how will it work so that 7 Units are added to Feb-03

 

[Dwight]

This board has a lot of posts giving examples of doing this type of thing. Just search under "Previous Record"

I recommend looking at Joh K's posts on the topic for guidance. They have helped me in the past.

Good luck.

 

[Sandip]

Previous Record For calculation

This board has a lot of posts giving examples of doing this type of thing. Just search under "Previous Record"

I recommend looking at Joh K's posts on the topic for guidance. They have helped me in the past.

Good luck.

Thanks
But
I Tried for Joh K's Post but could not find can any one can post sample database in zip form so i can view and can learn

 

[Dwight]

Pat gave you the solution. But here is more detail.

I'm guessing you have a table with your transactions. The additions should be positive and the subtractions should be negatives. Then you can use a crosstab query to add them up. Set the criteria to less than or equal to a date.

Crosstabs can be tricky if you have not used them before so you may have to experiment a little.

 

[ChrisO]

You could have a look at "Inventory Control: Quantity on Hand" on this site.

 

[Sandip]

Previous Record For calculation

You could have a look at "Inventory Control: Quantity on Hand" on this site.

Thanks
Loos very good site will try to learn from it


Hi
Still i could not resolve my problem. Can any one post simple database zip file so i can open and understand the same