Calculation between two dates

[Kipirich]

Hi There

Could anyone assist

I have a closing stock table that I want to use to calculate between two dates what the closing stock would be...For Example...I want to enter a starting date and an end date and all the relevant stock items must deduct from each other between those two dates.
I have a Product Table in relationship with my closing stock table.
Any suggestions or ideas. I am an intermediate user...
Thanks
kipirich


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[S.Clark]

"...all the relevant stock items must deduct from each other between those
two dates."
I don't understand the business rules involved in the deduction, but I guess
you could use an Update query to perform the deductions.