Question: 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,
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). Any help would be greatly appreciated!!!!!

5b User shall not spend more than $10,000 per month without approval. Save as 5b Query Display the name, total amount spent during the month and the month for all 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 5b User shall not spend more than $10,000 per month without approval. Save as 5b Query Display the name, total amount spent during the month and the month for all 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
