Searching for records with multiple entries in one field
I've got more questions concerning my database; here's a brief summary about it (if you don't recall/ didn't read my earlier posts....)
The database is a list of species; species name is one field, and in another, related tables, is a field called "geography" that lists all of the locations where that species occurs. How can I search for all of the species that meet a specific criteria: for example, I want to print a list of all the species that have these two specific entries into the geography field: North America and South America. I know that I can put my layout into find mode and type in "North America" into the geography field; this brings up too many entries, however: I don't want to see all of the species found in just North America, or North America and Africa, for example.