> Questions about creating a Query Average?

Questions about creating a Query Average?

Posted at: 2014-12-18 
his is the table



Give the table definition please.

So, I'm given a table (customer data), and asked to do the following:

1) create a query to display the average amount balance for sales rep 51.

2) create a query to display the average amount balance for each sales rep.

For 1), I opened a query, chose the sales rep # field, clicked on totals to choose to Avg. How do I show average for sales rep 51? This is the sales rep number you are asked to show the average for. I tried to type 51 in the criteria but it doesn't work.

2) is this the same as just choosing the average for all customers? if not, how do you choose average for each customer? do you do individually?

Thanks