Help with "mismatch in expression" error

  • Thread starter Thread starter RXLPA3
  • Start date Start date
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!!
 
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
 
Back
Top