In this query the [NameCounter] is a Family ID. The query returns many rows per family. How can I list a family only once.
I want to know if a family has made a contribution in 2012 or 2013
SELECT [NameCounter] ,[Amount],[CNDate]
WHERE [CNDate] > '2011-12-31' AND [CNDate] < '2014-01-01'
ORDER BY [NameCounter] ASC