Need help with unusual dedupe query

[ebecker]

I have the following query, that breaks one of our lists down by county and
zip code:

SELECT DNW.COUNTY, DNW.ZIP_CODE, [STREET] & ": " & [ADDRESSES] AS Household
FROM DNW
WHERE (((DNW.COUNTY)=[County? (IN CAPS)]))
ORDER BY DNW.ZIP_CODE, [STREET] & ": " & [ADDRESSES];

We're running into trouble because some of the zip codes cover more than one
county. How do I create a query where a user gives me a county I can pull
up a list of every street that has a zip code that is at least partly in that
county.

I know how to get a list of unique zip codes for a particular county.

SELECT DISTINCT DNW.COUNTY, DNW.ZIP_CODE
FROM DNW;

What I don't know how to connect the two. Thoughts or help that anyone could
provide would be most appreciated.