Query to look at latest info for multi transactions

[Palemo]

All transactions are in one database, all members are in one database. Transactions database holds the member id as well as subscription details.

We mail out on the last edition that the person is subscribed to.
The problem is, if that person has resubscribed he/she gets included in the mail out. The reason? They have two transactions in the table and because the expiry subscription ends on a particular number they are included ... it does not look for the latest on that member.

How do I get the query to look at the last transaction for that member (ie. if a member has two transactions recorded, ignore the first, and use the last expiry date).

 

[Jon K]

Take a look at this thread:-
http://www.access-programmers.co.uk/forums/showthread.php?threadid=42826

Hope it helps.

Edit:
In the example DB in the thread, LogID is an AutoNumber field.

If your table does not contain an AutoNumber field, you can use Max on the [Expiry Date] field when building the query qryOne.