Join

[Allison]

Is it possible to join a make table query ie.. the table
and a regular table by a certain field to use in creating
an update query???


The primary key is the same but I still receive a mismatch
in expression error when I try to join the two tables???

 

[John Vinson]

Is it possible to join a make table query ie.. the table
and a regular table by a certain field to use in creating
an update query???


The primary key is the same but I still receive a mismatch
in expression error when I try to join the two tables???

Please post the SQL view of your query and indicate the datatypes of
the joined fields.

You cannot join "a make table query" - it's an *action* query which
does someting (copied data into a new table), not a *select* query
which returns records.