I have a query in Access 2010 which is the datasource for a form. I'm trying to get average fields to work in the form but they stubbornly remain blank. I've tried it several ways:
Using datasheet view and turning on the Totals row. I set all three columns totals to Average, but they stay blank.
Using continuous form view, with fields in the footer. One example column field is Qty, so my formula in the footer is =avg([qty])... You can see my three footer fields glumly remaining blank.
As far as I can tell, all three columns are numbers, not text.
My source is a query that does do grouping and summarizing (Totals are turned on).