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
