Is there any way to calculate a running total in a query or report? My data has a beginning balance, planned usage by job, and planned purchases by Purchase order, that are unioned to a "Quantity" field. Somehow I need to calculate the projected inventory balance as of each date (record). I need more than a just an ending balance, I need the balance of of each date (record).