OK - I am following you. Something is wrong though, my query to get the last value, I followed as instructed but it is still pulling up all of the entries not just the last unless I remove the Donation_Amt. If I remove Donation_Amt it does pull up one instance of Key, Check Date. However, I...
Table 1 is called DATA and contains names, address info
and Table2 is called DONATIONS and contains donations (amount, check number, etc).
I have a query with a one-to-many relationship (on the field "KEY"). So any one person can have multiple donations. What I am trying to do is send a...