Show only the most recent record.

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Greetings,

I need to be able to show only the most recent contact with a customer. I
have created a query that has the person's name, contact date, and then
column that calculates the Date() - ContactDate. Now this does show me the
number of days since our last contact, but it calculates it for each record.

Can this be done? I would think so, but at this point, I have not found the
answer. Any help would be great.

Thanks,
Wayne
 
Wayne,
If you track ContactDate, then a "Totals" query with Max in the
ContactDate would yield the "latest" contact for each customer.
There's no need to subtract Date-ContactDate (ex.
[DaysSinceLAstContact]), but if you do, then you could then use a "Totals"
query and place a Min against the [DaysSinceLastContact] calculated field.
hth
Al Camp
 
Back
Top