Date Values

P

pkaynyc

I need to write a query that will return both the first and most recent gift
from each of a set of donors over the past five years. I need to list the
name, address, date and amount of each of the two gifts (assuming there are
more than one). Many Thanks, phil kay
 
J

Jeff Boyce

Phil

One approach might be to use two queries. One query to locate the
name/address/date/amount of the earliest gift made since (5 years ago).
Another to locate the most recent. A third, UNION, query could combine
those two together -- you'd want to be sure that if there was only one,
you'd only see one...
 
Top