Pulls out determined names and also the accepted one if there's synonymy involved.

acceptedNamesHerbQuery

SELECT Herb.[Collector Number], Lnam.[Full Name], LnSy.[Full Name] AS accepted, Geography.fullName, Team.Name
FROM (((((Determinations AS Dets RIGHT JOIN [Herbarium specimens] AS Herb ON Dets.[specimen key] = Herb.id) LEFT JOIN [Latin Names] AS Lnam ON Dets.[latin name key] = Lnam.id) LEFT JOIN [Synonyms tree] AS Synm ON Lnam.id = Synm.member) LEFT JOIN [Latin Names] AS LnSy ON Synm.[member of] = LnSy.id) LEFT JOIN Geography ON Herb.Locality = Geography.ID) LEFT JOIN Teams AS Team ON Herb.[Collector Key] = Team.id
WHERE ((Dets.Current)=True) AND ((LnSy.[Synonym of]) Is Null)
ORDER BY Herb.[Collector Number];