Date Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
Back
Top