Question: PLEASE HELP!!! MICROSOFT ACCESS QUERY QUESTION!! How would I perform these queries in Microsoft Access? Or at the very least, what criteria would I put

PLEASE HELP!!! MICROSOFT ACCESS QUERY QUESTION!!

How would I perform these queries in Microsoft Access? Or at the very least, what criteria would I put in/how should I structure the query to show the same vendor/cardholder combo appearing more than once on the same day??

There is only one table in the database, and the field names in that table are agencynumber, agencyname, cardholdername (purchaser), vendor, amount, transactiondate, posteddate, description, and merchantcategorycode(MCC).

PLEASE HELP!!! MICROSOFT ACCESS QUERY QUESTION!! How would I perform these queries

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 5f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!