Need help creating a report that shows multiple entries in a field
I am trying to create a report that generates a list of all of the species in my database that meet a certain criteria. I have two fields: species name and Geography (both are in different tables). I want to create a report that lists every species that has the same entries in the "Geography" field. So, far example, I want to be able to list all of the species found ONLY in North America, all of the species found in North AND South America, and all of the species found in North America and Europe. I think searching for all of the records containing a specific set of entries into a field should be simple, but for some reason I cannot figure it out. Thanks for your help!