I have a report that has these Headers: Model, Admin, IssueMiles, Turn In Miles, Total Miles, Avg Miles, Issue Hours, Turn In Hours, TotalHours, Avg Hours. I need to show an average of totals for that model type but only if nothing was entered in a field because sometimes no miles or hours are recorded and I don't know if that is going to be a problem.... I have unbound texboxes for the totals columns with =Sum([Turn In Hours]-[Issue Hours]) but I don't know the formula for bringing up an average for only specific model types or if it's possible. Thank you for help on this. Below is an example of what the outcome needs to be:
Model Admin Issue Miles Turn In Miles Total Miles Avg Miles Issue Hours Turn In Hours Total Hours Avg Hours Buffalo 6000 4173 4435 262 168 17 Buffalo 6004 2987 3027 40 1579 17 Buffalo 7265 24901 25226 325 2436 2474 38