Query by zipcode

[corpus]

I'm a bit new to access and not sure how I should go about doing this. I have a list of businesses located in new york, with their name, address, zipcode, and other demographics. I need to filter out all the rows of businesses that are located in new york city. To do this I got a database file with a list of all zip codes (5 digit format) that are considered new york city. So what I'd like to do is run a query based on the new york city zip codes and get a list of the businesses that are only located in nyc.

Another thing is that in the business database some zip codes are 5 digits others are in 9 digit format (xxxxx-xxxx), so I want it only to look at the first 5 digits as it filters out the zip codes im looking for.

I hope this isn't out of place.. thanks in advance.

-Michael

 

[lark_tilly]

Take a look at the attachment.
Query1 returns the business info with only a 5 digit zip.
Query2 joins Query1 to zipcode table and excludes the businesses with
a nyc zip.
Might be a simpler one query way to do this but it's late and my brain is tired.