Join

  • Thread starter Thread starter Allison
  • Start date Start date
A

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???
 
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???
Click to expand...

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