Is it possible to have the query below, give me a count but only 1 count per softslip. So if the animal had more than one "note" it only gets counted once. Or can someone create a new query using the information below? Points are high because I need this today.
SELECT Count(Notes.SoftSlip) AS CountOfSoftSlip, Species.Species
FROM Species INNER JOIN (Notes INNER JOIN SoftSlips ON Notes.SoftSlip = SoftSlips.SoftSlip) ON Species.SpeciesID = SoftSlips.SpeciesID
WHERE (((Notes.NoteDate) Between [forms]![frmSwitchboard]![txtStartDate] And [forms]![frmSwitchboard]![txtEndDate]) AND ((SoftSlips.Location) Like "*" & [Enter Location] & "*") AND ((Notes.NoteType)="Trainer"))
GROUP BY Species.Species;