Last Date Query

[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

 

[John W. Vinson]

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

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.