Have you tried a Dmax function on the date paid field? or does your table have an order number field?
--- In [email protected], "Norman Pearce" <[EMAIL PROTECTED]> wrote: > > In a membership database, I have a table tblSubscriptions. > Several fields, but essentially MemID, DatePaid & AmountPaid. > > I want to create a query to display only the latest record for each > member. > > Any guidance would be very much appreciated. > > Norman Pearce >
