Up Date Querie using two tables

[Jacob-Bushnell]

OK, I have gotten thru the first step. I have now updated fields with in the same table. I used the Expresion builder to make the following querie:

UPDATE LORTON SET LORTON.ADDRESS = LORTON!COA_DELADR, LORTON.CITY = LORTON!COA_CITY, LORTON.STATE = LORTON!COA_STATE, LORTON.ZIP = LORTON!COA_ZIP
WHERE (((LORTON.COA_DELADR) Is Not Null));

It worked great!

Here is my next step: I need to update fields with data from different tables.

I exported the table with the new data into my existing data base.

Here is what I tried so far:

1.) I Tried using the expresion builder and came up with this:

UPDATE TblFamilies, LORTON SET TblFamilies.MailAddr1 = [LORTON]![ADDRESS];

I came up with hundreds of the same record.

2.) I then tried to create a relationship between the two tables. The fields are named the same "FAMILY ID". The data type in my main table is "auto number" and in the one I exported into the data base has a "text" data type. When I linked the tables and then run my querie I get a "type mismatch in expression" error



What am I doing wrong?

 

[bjackson]

your data type FAMILY ID,needs to a number,at the moment
you are trying to compare a number(autonumber) with a text value-even though your FAMILY ID may well be numeric,access looks at it as data type text