AnsweredAssumed Answered

Searching for records with multiple entries in one field

Question asked by NTH23 on May 26, 2009
Latest reply on May 29, 2009 by TSGal

Title

Searching for records with multiple entries in one field

Post

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.

Outcomes