Page 1 of 1

As of Date

Posted: Tue Jun 24, 2003 10:47 am
by SMZ_(Guest)
I need to create an inventory report that can print out what the inventory was "As of " a certain date (i.e. today we want to print an inventory report as of 2/25/03). How do I do this?

=> RE: As of Date

Posted: Tue Jun 24, 2003 2:18 pm
by kfleming
You would need to have a starting balance field and then a quantity ordered/quantity sold transaction field. You would the use a query to select all records within the date range and then compute beginning balance + ordered - sold.______Kathleen__R&R Support