Fields not displaying in report - query may not be accurate

[laina222]

I have two queries I'm using for one report. Query1 is data from my table by date range, so that the user enters the start and stop date and gets all records for that range. Query2 refers to my first query mentioned, getting the averages and totals only for the data in the first query by the specified date range.
When I run the report, it first asks me for the start date and then the end date. Then it asks for the value of Query2. Obviously I don't want to enter anything, so I click "OK" and it displays the report. The individual records for Query1 display accurately, but the Averages and Totals below have "#Error" displayed instead of the values. In their control source I have "=Query2.Average", etc, but the values don't calculate and/or display correctly. Any ideas?

 

[dhookom]

A report has only one record source. You can't use an expression like =MyQuery.MyField in a control source. You can use function like DLookup().

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