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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 15 May 2005 11:58 GMT

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?

Reply to this Message

Jeff Boyce - 15 May 2005 12:32 GMT

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.

Signature

Good luck

Jeff Boyce
<Access MVP>

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

Reply to this Message

Paul - 15 May 2005 13:43 GMT

Jeff

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

Paul

> Paul
>
[quoted text clipped - 8 lines]
> >
> > Can anyone help?

Reply to this Message

Jeff Boyce - 15 May 2005 21:59 GMT

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).

Signature

Good luck

Jeff Boyce
<Access MVP>

> Jeff
>
[quoted text clipped - 15 lines]
> > >
> > > Can anyone help?

Reply to this Message