Showing only the most recent date

[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

 

[AlCamp]

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

 

[Thrava]

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




.