Calculation between two dates

  • Thread starter Thread starter Kipirich
  • Start date Start date
K

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/ =-
 
"...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.
 
Back
Top