I'm looking at trying to determine, for each member in the system, the last receipt they appeared on. The tables look as follows (in brief):
Receipts: Unqiue ID, Member ID, Receipt Date
Each member can appear multiple times in the table. What I want is, for each member, provide me the unique ID for the last receipt they appeared on based on receipt date.