Average pay rate and total number of employees

[Cmd2483]

I am trying to figure out how to create a query where I can display the average pay rate and the total number of employees in each department. I am having a hard time trying to figure this out. Any help would be greatly appreciated!! Thank you!!

[pbaldy]

Start a query with those 3 fields selected. Click on the Totals icon, then change Group By to Count on the employee field and to average on the salary field.