Code:
SELECT PersonMembership.OrganizationId, v060ClubOfficersPresOrNot.ClubNo, v060ClubOfficersPresOrNot.SortName, v060ClubOfficersPresOrNot.ClubName, v060ClubOfficersPresOrNot.Contact, v060ClubOfficersPresOrNot.[USFSA#], v060ClubOfficersPresOrNot.StreetOne, v060ClubOfficersPresOrNot.StreetTwo, v060ClubOfficersPresOrNot.CareOf, v060ClubOfficersPresOrNot.City, v060ClubOfficersPresOrNot.State, v060ClubOfficersPresOrNot.PostalCode, v060ClubOfficersPresOrNot.OrgType, v060ClubOfficersPresOrNot.ClubRegion, v060ClubOfficersPresOrNot.ClubSection, v060ClubOfficersPresOrNot.Email, v060ClubOfficersPresOrNot.Phone, v060ClubOfficersPresOrNot.FirstName, v060ClubOfficersPresOrNot.FacilityName, v060ClubOfficersPresOrNot.PresClubSec, v060ClubOfficersPresOrNot.[PresUSFSA#], v060ClubOfficersPresOrNot.PresCareOf, v060ClubOfficersPresOrNot.PresAdd1, v060ClubOfficersPresOrNot.PresAdd2, v060ClubOfficersPresOrNot.PresCity, v060ClubOfficersPresOrNot.PresState, v060ClubOfficersPresOrNot.PresZip, v060ClubOfficersPresOrNot.President, v060ClubOfficersPresOrNot.PresEmail, v060ClubOfficersPresOrNot.PresPhone, v060ClubOfficersPresOrNot.StatusId, v060ClubOfficersPresOrNot.URL, v060ClubOfficersPresOrNot.Certified, v060ClubOfficersPresOrNot.Code, v060ClubOfficersPresOrNot.FacilityLastUpdate, v060ClubOfficersPresOrNot.ByLawsUploadDate, v060ClubOfficersPresOrNot.BSProgram, v060ClubOfficersPresOrNot.ProgramStatusId, v060ClubOfficersPresOrNot.Status, v060ClubOfficersPresOrNot.IsActive, PersonMembership.MembershipTypeId, PersonMembership.EndDate, PersonMembership.InvoiceNumber, PersonMembership.PaymentDate, PersonMembership.PersonId, Year([EndDate]) AS EndYear
FROM v060ClubOfficersPresOrNot LEFT JOIN PersonMembership ON v060ClubOfficersPresOrNot.ClubID = PersonMembership.OrganizationId
GROUP BY PersonMembership.OrganizationId, v060ClubOfficersPresOrNot.ClubNo, v060ClubOfficersPresOrNot.SortName, v060ClubOfficersPresOrNot.ClubName, v060ClubOfficersPresOrNot.Contact, v060ClubOfficersPresOrNot.[USFSA#], v060ClubOfficersPresOrNot.StreetOne, v060ClubOfficersPresOrNot.StreetTwo, v060ClubOfficersPresOrNot.CareOf, v060ClubOfficersPresOrNot.City, v060ClubOfficersPresOrNot.State, v060ClubOfficersPresOrNot.PostalCode, v060ClubOfficersPresOrNot.OrgType, v060ClubOfficersPresOrNot.ClubRegion, v060ClubOfficersPresOrNot.ClubSection, v060ClubOfficersPresOrNot.Email, v060ClubOfficersPresOrNot.Phone, v060ClubOfficersPresOrNot.FirstName, v060ClubOfficersPresOrNot.FacilityName, v060ClubOfficersPresOrNot.PresClubSec, v060ClubOfficersPresOrNot.[PresUSFSA#], v060ClubOfficersPresOrNot.PresCareOf, v060ClubOfficersPresOrNot.PresAdd1, v060ClubOfficersPresOrNot.PresAdd2, v060ClubOfficersPresOrNot.PresCity, v060ClubOfficersPresOrNot.PresState, v060ClubOfficersPresOrNot.PresZip, v060ClubOfficersPresOrNot.President, v060ClubOfficersPresOrNot.PresEmail, v060ClubOfficersPresOrNot.PresPhone, v060ClubOfficersPresOrNot.StatusId, v060ClubOfficersPresOrNot.URL, v060ClubOfficersPresOrNot.Certified, v060ClubOfficersPresOrNot.Code, v060ClubOfficersPresOrNot.FacilityLastUpdate, v060ClubOfficersPresOrNot.ByLawsUploadDate, v060ClubOfficersPresOrNot.BSProgram, v060ClubOfficersPresOrNot.ProgramStatusId, v060ClubOfficersPresOrNot.Status, v060ClubOfficersPresOrNot.IsActive, PersonMembership.MembershipTypeId, PersonMembership.EndDate, PersonMembership.InvoiceNumber, PersonMembership.PaymentDate, PersonMembership.PersonId, Year([EndDate])
HAVING (((Year([EndDate]))=Year(Date()) Or (Year([EndDate])) Is Null));