A
Allen Browne
You don't.
You create a related table, where, you have multiple *records* instead of
multiple fields.
Then you create a query into this table, make it a Totals query (View menu),
group by whatever fields you want, and use the Avg choice in the Total row
to get the correct average with nulls omitted from the calculation.
You create a related table, where, you have multiple *records* instead of
multiple fields.
Then you create a query into this table, make it a Totals query (View menu),
group by whatever fields you want, and use the Avg choice in the Total row
to get the correct average with nulls omitted from the calculation.