Answer by
belindagold (39)
Access 2007, go to the Create ribbon, select Simple Query Wizard, Add the applicable fields to the query, Choose Next, Select SUMMARY, then select summary options. This will display the fields that are eligible for count, sum, average, and Max. In the lower right hand corner, there is also a "count" function.