Query problem

[ccordner]

I am trying to build a pretty straightforward query. I want to pull fields from two tables (with a common primary key) and then filter them.

I have followed the access "Simple Query Wizard" but when I try to actually view the query results, it says "Type mismatch in expression".

If I just use one table, it's fine. As soon as I even add the table (in design mode), it starts coming up with the error when I try to run the query: even though I haven't actually added any of the fields into it.

Any ideas why?

I'm not very good with access, so it could be something pretty stupid!

Thanks
Chris

 

[boblarson]

Make sure the fields you are linking between the two tables are the exact same datatypes.

 

[ccordner]

So simple! Thanks.

When I set the table up I did it as a "Lookup", so it never occurred to me to check they were the same!

Thanks
Chris

 

[boblarson]

When I set the table up I did it as a "Lookup",

Just an FYI for you:
http://www.mvps.org/access/lookupfields.htm