Help with "Mismatch in Expression" error...

  • Thread starter Thread starter RXLPA3
  • Start date Start date
R

RXLPA3

I am getting the following error when running my update query

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

Does anyone see any errors?

If you need any other information please let me know as I have only
been using access for 2 weeks....



Thank YOU!!
 
Are the fields the same type in both tables?
--CustName in both tables of the same data type?
--Cust in both tables of the same data type?
--Store in both tables of the same data type?

One other thing to try is to replace the ! with a period in
SET tblCardinalPurchases.Store =[tblKrogerStores].[Store]

Another thing to check is whether or not the Store fields both allow or
don't allow zero-length strings.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top