Last Date Query

  • Thread starter Thread starter Mark H
  • Start date Start date
M

Mark H

I have a table with sales data in it (customer #/Cust Name/Invoice Date/Sales
$$)
I want to create a query where I can look at each customer and see their
last invoice date.

End Result:
Cust Name Invoice Date
Cust 1 4/20/08
Cust 2 5/20/09
Cust 3 3/31/09

Thanks in Advance for your help,
please let me know if you need more information.

Mark H
 
I have a table with sales data in it (customer #/Cust Name/Invoice Date/Sales
$$)
I want to create a query where I can look at each customer and see their
last invoice date.

End Result:
Cust Name Invoice Date
Cust 1 4/20/08
Cust 2 5/20/09
Cust 3 3/31/09

Thanks in Advance for your help,
please let me know if you need more information.

Mark H
Click to expand...

Create a new Query based on the table. Select the Cust Name and Invoice Date
fields (and nothing else).

Click the Greek Sigma icon (looks like a sideways M) to make it a Totals
query.

Leave the default Group By on Cust Name, and change it to Max on the Invoice
Date.

Open the query, and/or base a Form or Report on it.
 
Back
Top