I am fairly new and beating myself up trying to figure this out.

I have a report that shows a list of products sold per day by category - using a date range as parameters in the main query... ie, to show daily totals for a whole month, for example. In the section footer it has a total for each day, and finally a grand total at the end.

I want the grand total for each day, but I also want the totals of only certain "product categories" for that day as well broken out separately.

So, I wrote a few Queries that count only the totals for that date for those special product categories using a single date as the input parameter.

Now, how can I pass the single [Date] value from the report to the query in the Control Source for those text boxes on the report??

Alternatively, I tried doing a Sum() on a textbox in the details section whose control source was an IIF function for those special product categories, but that didn't seem to work either. Maybe that is the right track, but I wasn't doing it right.

I could potentially re-write the main report query, but I'm trying to avoid that for fear of breaking what is already being pulled today. The information is there, I think I just need to weed out the numbers correclty.

Thanks in advance.