Answered step by step
Verified Expert Solution
Link Copied!

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!!!!!

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Application Development And Design

Authors: Michael V. Mannino

1st Edition

0072463678, 978-0072463675

More Books

Students also viewed these Databases questions

Question

1. How is the newspaper help to our daily life?

Answered: 1 week ago

Question

1. Prepare a short profile of Mikhail Zoshchenko ?

Answered: 1 week ago

Question

What is psychology disorder?

Answered: 1 week ago