Just when you solve one issue another jumps up at you. I am trying to average in my weekly report with little success.
In my footer i created a text box and entered = AVG([avgofperformance]) where avgofperformance is my field name, The only thing I can think of that is messing with it is that these figures are already averages of individual task.
The associate would do work all day and get a performance score for every task they perform. Those individual scores are then averaged together to get a daily average. With my weekly report I am taking all the daily averages and trying to create a weekly average.
when you open the db click on the weekly report in the reports section. You will be prompted to enter a name. please enter Banta, Ron. You will then be asked for date range. 10/9 - 10/12 is the start and end dates. You will then see what I am looking at.
Any thoughts about what is going on?