Eightball3
Programmer
This is tough to describe but here goes..
I have a report that is grouping by 'make'. The report averages the hours charged by the mechanic for each specific make. Within that same grouping I have a textbox query the history table of all items completed by that make by anyone and averages the hours charged to that make. So I end up with a persons average charge time compared to the same items averaged charge time historically. This all works fine. The problem comes at the report footer when I want to Average the Averages for both the mechanic and the history to show an overall comparison. I get error messages referring to both of the average textboxes when trying to compute the overall average. I hope this isn't too confusing.
I have a report that is grouping by 'make'. The report averages the hours charged by the mechanic for each specific make. Within that same grouping I have a textbox query the history table of all items completed by that make by anyone and averages the hours charged to that make. So I end up with a persons average charge time compared to the same items averaged charge time historically. This all works fine. The problem comes at the report footer when I want to Average the Averages for both the mechanic and the history to show an overall comparison. I get error messages referring to both of the average textboxes when trying to compute the overall average. I hope this isn't too confusing.