Max Date

[Haji]

Hello,

I have two fields in my SalesDate table. CustomerID and
Date. CustomerID will often appear several times always
with a different date. I want to write a query that will
only have the customerID appear once and have the most
recent date listed as well. How do I do this?

Thanks,

Haji

 

[Joshua A. Booker]

Haji,

Open the Query in design view
Click the Totals button on the tooolbar (sum symbol)
in the Totals Row below SalesDate change from GroupBy to Max. If you have
other fields such as OrderID, they will have to be something other than
GroupBy or removed.

Read about Totals Queries or Aggregate Queries in Access help for more
details.

HTH,
Josh