I am trying to pull Club Records, but I cannot seem to filter opposition out of the data. For example if I pull a list of centurions it also includes centurions from opposition teams which is not what I want as I just want my clubs players?
top of page
Top Suggestions
bottom of page
I think I can see the issue.
You have named your database Plymstock Cricket Club but that is the whole database.
I see that you have around 4 "plymstock" clubs. If you select any of these as the "Club" for the report then it will filter out the opposition.
You probably should have just set up one Plymstock club (and just name it Plymstock) and then the others could be set up as teams. That way, you can just select Plymtock and it will include all your teams. It is not too late to do this.