Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How would I perform these queries in Access? The table names are agencynumber, agencyname, cardholdername, vendor, amount, transactiondate, posteddate, description, and merchantcategorycode(MCC). Any help would
How would I perform these queries in Access? The table names are agencynumber, agencyname, cardholdername, vendor, amount, transactiondate, posteddate, description, and merchantcategorycode(MCC). Any help would be greatly appreciated!!!!!
5d 5e An amount more than $5,000 Display all transaction details where the should not be split between two or vendor and purchaser are the same on more swipes of the card by the a specific day, there is more than one same person. Save as 5d Query transaction for the day and the combined total of the transaction was more than $5,000. Sort them in ascending order by the TransactionDate. Purchases should not be split To simplify, we only will consider between two or more cardholders. splitting these between two people. Save as 5e Query Display all transaction information in which the combined total for a vendor on a day was more than $5,000 and there were two different cardholders who made a purchase from that vendor (make sure the query excludes people who may have made double payments). Sort them in ascending order by the TransactionDate. Purchases should not be split To simplify, we will only consider between two or more vendors. splitting these between two vendors. Save as 5f Query Display all transaction information in which the combined total for a person on a day was more than $5,000 and there were purchases made at two different vendors (make sure the query excludes people who may have made double payments at one vendor). Sort 5f 5d 5e An amount more than $5,000 Display all transaction details where the should not be split between two or vendor and purchaser are the same on more swipes of the card by the a specific day, there is more than one same person. Save as 5d Query transaction for the day and the combined total of the transaction was more than $5,000. Sort them in ascending order by the TransactionDate. Purchases should not be split To simplify, we only will consider between two or more cardholders. splitting these between two people. Save as 5e Query Display all transaction information in which the combined total for a vendor on a day was more than $5,000 and there were two different cardholders who made a purchase from that vendor (make sure the query excludes people who may have made double payments). Sort them in ascending order by the TransactionDate. Purchases should not be split To simplify, we will only consider between two or more vendors. splitting these between two vendors. Save as 5f Query Display all transaction information in which the combined total for a person on a day was more than $5,000 and there were purchases made at two different vendors (make sure the query excludes people who may have made double payments at one vendor). Sort 5fStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started