Question: MICROSOFT ACCESS QUERY QUESTION!!!!! PLEASE PLEASE PLEASE HELP ME!!!! How would I build this query in Access? There's only one table, and the field names

MICROSOFT ACCESS QUERY QUESTION!!!!! PLEASE PLEASE PLEASE HELP ME!!!!

How would I build this query in Access? There's only one table, and the field names are cardholder, transactiondate, posteddate, vendor, amount, description, merchantcategorycode. How would I display the records where the same cardholder/vendor combo appears more than once on the same day?

Display all transaction details where the vendor and cardholder are the same on a specific day, there is more than one transaction for the day and the combined total of the transaction was more than $5,000. Sort them in ascending order by the TransactionDate.

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!

MICROSOFT ACCESS QUERY QUESTION!!!!! PLEASE PLEASE PLEASE HELP ME!!!!!!!!!! How would I build this query in Access? There's only one table called "Marie", and the field names are cardholder,...

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

Please answer the questions that are highlighted with steps on Microsoft Access B20 B30 B60 B70 B80 MISC311 Spring 2021 MAKEUP/RETAKE Access Exam: Carl's Construction 1. Description 1). Customers...

1) Create a query to determine the amount of revenue by trip based on the current number of customers in reservations. Your query should list each river trips TripID, RiverName, and Revenue. The...

Please please help me with this! No one has answered the other questions I posted! How would I perform these queries in Microsoft Access? Or at the very least, what criteria would I put in/how should...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

The Spartan Manufacturing Company produces products A, B, and C. Although Spartan could sell up to 50 units of A, 60 units of B, and 50 units of C each week, a limitation of 400 machine-hours per...

On January 1, Pulse Recording Studio (PRS) had the following account balances. The following transactions occurred during January. 1. Received $ 2,500 cash on 1/ 1 from customers on account for...

Question 5 Dividend Payout Ratio is: Answer area PAT Capital D P S EPS Pref. Dividend PAT Pref. Dividend Equity Dividend

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Would you say that effective teamwork saved their lives?

8. Do you believe that others can compete but that they also can choose to cooperate? __ always __ usually __ occasionally __ seldom __ never true?

1. What happens to conflicts as relationships become closer, more personal, and more interdependent?