I have a table called CPW Detections and it looks something like this in the columns
|Site|Set Date|Removal Date|Point Location|Species 1|Detection 1|Species 2|Dectetion 2| and so on..
What i would like to do is find all the rows (including site, removal date, point location) that have (for example) the field “Numbat” and its # of Detections (Detections column). Now the Numbat could be in any of the Species 1 through to Species 21 Columns. How can i do this and how can i do it so that i can find any specific species?