In MS Access 2003, I need to find the Max date on Invoices for each client and the Seller's name.

Posted on 2010-01-07
Medium Priority
Last Modified: 2013-11-28
In MS Access 2003, I need to find the most current date (MAX?) of an invoice for each client and the seller's name.  the end results need to have
CLIENT, Last Invoice, SELLER in the output.

If necessary, I can forgo  having the SELLER name.
Question by:PorterConsultingLLC
  • 2
  • 2

Author Comment

ID: 26202018
SORRY!! i need these fields:

LVL 61

Expert Comment

ID: 26202268
what are the tables involved and their structures? post a sample data from each table and expected result...
LVL 61

Accepted Solution

HainKurt earned 2000 total points
ID: 26202294
try this:

select client, seller, max(inv_date) as max_inv_date
from invoice
group by client, seller

Author Closing Comment

ID: 31674104
BLESS YOU!  Although this gives me more than one last invoice if there is more than one seller per client, this is a useful answer.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question