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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Jeff

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

Paul
 
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).
 
Back
Top