As of Date

[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?

[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