Hi! My first ever post to a forum like this, so bear with me!
I have data from a inventory of plant species and wish to show the data in a certain way. I want to show certain combinations of species that have been found in locations together (i.e. show a list of locations where species A and species B were found together). The fields I want to show data from are: Species, Location ID, Location, Habitat type. And specifically the locations where the 2 species in question were found together. The two tables are linked together via the Location ID fields.
Attached is a screenshot of my query setup.
I hope the information is sufficient, and I hope there exists an answer to my question! It feels like a simple enough request of Access.
Greetings,
Erika Nystöm