Query Multiple Zip Codes

[JackL290]

I have two tables, "Members" and "Zip Codes"



I want to query all "Members" who live in any of the zip codes in "Zip Codes"

There are over 900 zip codes in "Zip Codes"

The two tables are not joined

[orange]

If the tables are not joined, what info is in "members" that identifies the Zip code?

[JackL290]

The "Members" table was imported from an Access Spreadsheet. It contains a field [Zip Code] that is not joined to table "Zip Codes." Table "Zip Codes" is a single field table with no ID field. I copy/pasted the zip codes from a web tool used to generate a list of zip codes in a radius. All records in "Zip Codes" are unique. Multiple records in the [zip code] field of "Members" could be in the same zip code.

[June7]

Then build a query that does an INNER JOIN of the tables.