totals on date range report

[lawrmc]

Hi,
I have been messing around with queries and reports to try and accomplish the following.

I have a rental db that has the following.

tblProd Holds all rental products
tblRental Rental sales
tblCat categories of products

I am trying to build a report that will show rentals for a time period "select.....where... between [start date] and [end date]"

This part is OK and the report based on that query shows all products grouped and the dates rented, cost etc.

What I am trying to do and failing miserably is have for each category group a total of all cost for all rentals and not just the date range.

At the moment it will only total all cost for the inputted date range.

Anyone have any suggestions?

Cheers
lawrmc

 

[dhookom]

You can create a totals query that groups by fields to the level of detail required in your report (either category or product) and sums cost. Don't set any date range on this query. Add this totals query to your report's record source query and join the appropriate fields. You can then add the SumOfCost to your report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lawrmc]

Works a treat, couldn't get the queries to work myself. Two heads are always better than one.
Much appreciated!!