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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part 2 Lnai 8725
Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo
2014th Edition
3662448505, 978-3662448502
