Querying the latest

[John F Kappler]

I have a Table full of records of Events that each Customer has
attended.

The records have a customer Number and the event details including the
Date

I've been struggling with building a Query that will return only the
records for the most recent event for each (but every) Customer.

Could someone pls put my brain out of its misery?

TIA,

JohnK

 

[Allen Browne]

See:
Queries: Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for four ways to approach this query.