Help with "mismatch in expression" error

R

RXLPA3

I am getting the following error when trying to run my update
query...does anyone see any errors?


UPDATE tblCardinalPurchases INNER JOIN tblKrogerStores ON
(tblCardinalPurchases.CUSTNAME = tblKrogerStores.CUSTNAME) AND
(tblCardinalPurchases.CUST = tblKrogerStores.CUST) SET
tblCardinalPurchases.STORE = [tblKrogerStores]![Store];

Let me know if you need additional information, as I have only been
working with Access for 2 weeks.

Thank YOU!!
 
C

Carl Rapson

I am getting the following error when trying to run my update
query...does anyone see any errors?


UPDATE tblCardinalPurchases INNER JOIN tblKrogerStores ON
(tblCardinalPurchases.CUSTNAME = tblKrogerStores.CUSTNAME) AND
(tblCardinalPurchases.CUST = tblKrogerStores.CUST) SET
tblCardinalPurchases.STORE = [tblKrogerStores]![Store];

Let me know if you need additional information, as I have only been
working with Access for 2 weeks.

Thank YOU!!
Click to expand...

Are the data types of CUSTNAME, CUST, and STORE the same in both tables?

Carl Rapson
 
Top