How would I perform this query in Access? I'm supposed to have 14 total records in the completed query. The table names are agencynumber, agencyname, cardholdername, vendor, amount, transactiondate, posteddate, description, and merchantcategorycode(MCC).

5b User shall not spend more than Display the name, total amount spent $10,000 per month without during the month and the month for all approval. Save as 5b Query employees who spent more than $10,000 per month in 2014. Sort by month (January listed first) and then total the amount spent with the larger Amounts listed first