Question: 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
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, 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.
I should end up with 63 records in the final query. No SQL please, just tell me how to build it in Access DesignView!! Thank you!!!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
