Access 2000 gives error message "type mismatch in expression" in .

P

Paul

I'm trying to build a report and a query from several tables using the
wizard. On going into preview I get a message "type mismatch in expression.
I've not included an expression in either item.

Can anyone help?
 
J

Jeff Boyce

Paul

One reason for this error message is because the join fields between tables
are of different data types. Re-check all your joins and the fields they
use.
 
P

Paul

Jeff

Thanks for a speedy responsse. All the join fields are auto number to auto
number so should be OK

Paul
 
J

Jeff Boyce

Paul

An Access Autonumber field is used to independently and uniquely identify a
table's rows. Thus, the Autonumber values in table1 will have NO
relationship to the Autonumber values in table2. If your tables are related
one-to-many, you need to be using a foreign key field of type Long Integer
in the many table to record the "parent" record's Primary Key value (which,
in the "parent" will be an Autonumber).
 
Top