How would I build this query in Microsoft Access? 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.

There's only one table called "Marie", and the field names are cardholdername, 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?

I should end up with 63 records in the final query