Eileen, I tried Dmax, but could get it to work in my situation. However, Dana's query/subquery works well so haven't pursued DMax any further. Thanks for your response though.
Regards Norman Developing the foundations for your success -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eileen1309 Sent: 14 February 2007 20:54 To: [email protected] Subject: [ms_access] Re: Display latest Payment only Have you tried a Dmax function on the date paid field? or does your table have an order number field? --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, "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 > [Non-text portions of this message have been removed]
