MS Access #Error in Report with Query Source in Calculating Currencty Avg, Queried by Date Parameters
Posted on 2007-10-07
I'm using MS Access 2003. I've created a query with date parameters to give me the AppWorth values for Donations from a Table name DonationTbl. The name of the query is WeeklyDonationsAvg and the name of the report is WeeklyDonationsAvgRpt. I am trying to calculate the Average of the AppWorth in the Page Footer of the report.
I get a #Error when I try to run the report using =Avg([AppWorth]) or using Sum("[AppWorth]")
No matter how I put it, I still get the #Error. Both AppWorth is Currency Format and so is the label, which is label12.
Thanks again, for your assistance..