When you need quick answers to everyday business questions, let Access' Crosstab Query Wizard help. ... Using the AVERAGE function, you might enter: =AVERAGE(B3:B23).

Here's a way to make consistent Access reports from similar data, while allowing your users to set their own data parameters. Topic — Software Account Information ...