Update Error

[mboe]

I have two identical tables with one being created by coping the structure of the other. Table A is my primary table. Table B is my new data imported table. I created a Update query with a dlookup to update Table A's address field from Table B. All records fail to append due to type conversions.

Here is the dlookup:
DLookUp("[Address]","Table_B","[ID_number] = " & [ID_number])

I need this to work and I have no idea why I am getting the conversion problem.

 

[pdx_man]

Hmmm ... why are you using DLookUp?

UPDATE Table_A
SET Address = Table_B.Address
FROM Table_A
INNER JOIN Table_B
ON TableA.ID_Number = TableB.ID_Number

 

[mboe]

Apparently I am not getting enough sleep. Thanks.