Type Mismatch in Expression"?

[DeniseGearhart]

I am new to Access 2010 and am trying to build a query of MI counties and survey which includes MI zip codes. In the end I need a Report by county of survey results (which includes the zip codes). I have a table with zipcodes, counties and cities and another table with the survey which contains zipcodes. When I try to build a query with the County from one table with the ZipCodes and other fields from the Survey table I get an error message.



The query contains an error "type mismatch in expression". I don't know how to fix it. Are the join types correct? Or what do I need to change? I thought that if I linked the zip code from the survey with the zip codes/counties from the Zipcode Table it would work.

Any ideas?

[pbaldy]

Are the fields being joined on of similar data types?

[DeniseGearhart]

I am struggling to figure out what I should join--the Zip codes from each table? The ID from the Zip code Table with the Zip Code field from the Survey table (this lists Vendor, Zip Code and other questions in dropdown value lists--a list of breads, a list of tortillas, a list of deliver times, etc.)?

Since my initial post I realized that the problem is in the Relationship. But they have to be related in order to reference a zip code/county table to a Survey table with each zip code. I need to list the Vendor Survey results by County, but the zip codes provide the link.

Do you have an answer?

[pbaldy]

You didn't answer my question. Can you post the db here?

[DeniseGearhart]

Thanks for asking about relationships. Unfortunately, my database was too large to post. I figured out that I could join the Zip Codes from each table and I changed the Join Type to include all of the Vendor Survey Zip Codes and only the Zip Codes from the Zip Code table which are the same. It worked.

Building a Query/Report for each Bread and Tortilla (about 25 items) and need to figure the % of Vendors who carry each. Do you have any idea how I can start this?

I think I need to build a parameter query. I suppose I need to set up a form where one can choose the item from a list then run a query that calculates the % of Vendors out of the total number of vendors. This could be a Report which lists each Bread and Tortilla, then the % of Vendors which carry this item.