Hi I am not sure how to explain what I need but I'll try. I need a query (if there is one) for counting if a tally was present in a point (column). So all species with more than one tally in a point will count only as one.
This is how the data looks: Sp Site Pnt1 Pnt2 Pnt3 Total A 1 1 1 1 3 A 2 1 1 2 A 3 1 1 B 1 1 1 1 3 B 2 1 1 C 1 1 1 2 C 2 0
I want to count if the sites have tally or not and if they are repeated by points (for the same species) I want to count them as one. I would like the resulting table to look like this.
Sp Pnt1 Pnt2 Pnt3 Total A 1 1 1 3 B 1 1 1 3 C 0 1 1 2
Thanks for all the help you can provide.
