Showing only the most recent date

  • Thread starter Thread starter thrava
  • Start date Start date
T

thrava

Hi everyone,

I hope someone can help with this.
Im querying a table that has customer names, address and
date service was rendered to them.
The date field is formatted as date.

In the query pane, what formula do I write in
the "Criteria" so that only the most recent date for each
customers are shown? I think I need to use DMax, but I
have no idea what the syntax should be like.

Customer name field is called "CustName" Date field is
called "VisitDate"

Thanks
Thrava
 
Thrava,
You need to create a Totals query. Use a normal Select query, Select
View/Totals from the menu, and use Group By in the Totals: row of the
Customer column and Max in the Totals: row of VisitDate.
hth
Al Camp
 
Thank you
-----Original Message-----
Thrava,
You need to create a Totals query. Use a normal Select query, Select
View/Totals from the menu, and use Group By in the Totals: row of the
Customer column and Max in the Totals: row of VisitDate.
hth
Al Camp




.
Click to expand...
 
Back
Top