Greetings to the well of knowledge...
I'm at a loss on this particular query design.
We have a table of donors that contains the donor's name, the date of the donation, and the amount of the donation (among other fields). A user would like a list of all donors with the date and amount of the donors' most recent donation. A top values query is not what I'm looking for. Can someone offer a solution?
Thanks,
Ken
I'm at a loss on this particular query design.
We have a table of donors that contains the donor's name, the date of the donation, and the amount of the donation (among other fields). A user would like a list of all donors with the date and amount of the donors' most recent donation. A top values query is not what I'm looking for. Can someone offer a solution?
Thanks,
Ken