YTD in Report

[Guest]

I have a report that is for shipping Laundry daily. What is reported in the
report is the quantity of each laundry product and the product name that is
both shipped and received. What I would like to do is include, at the end of
each Product record, the year to date total of that product including the
laundry that the customer is receiving. This total would be what the customer
has in his possion, giving him a year to date sum of product he has for a
daily inventory count.

The report uses a query [ProductRental] that extracts the products shipped
and received to/from the customer based on the dateTransactionDate. I think I
somehow need to use the numbers from a query [ProductRentalTotals] that
groups the products by customer and also has an expression that gives the
total that I am looking for in the report [ProductRentalTotals].[In House
Inv]. My problem is how do I either run both of these queries in the same
report linking them by productID to report in a unbound field or some other
way to provide this expression?

Thanks,

Dennis

 

[Guest]

You could also use the DSum Function, like

Dsum("[quantity]","TransactionTable","year([DateField])=" & year(date()) & "")