append query error "invalid argument"

[Rick]

hi all,
using access 2003 on a win xp computer. i have set up an append query to
append 2 fields from table root_SERV_CALL to 2 fields in Table1.

the field names in root_SERV_CALL are MODEL and SERIAL. i want to append
this data to Table1 using field names Item_ID and Serial_ID.

when i run the query, i get an error for "invald argument". looking in
access help only tells me there is a problem with an argument to a dll. not a
lot of help.

here is the sql that was created when i setup the query:

INSERT INTO Table1 ( Item_ID, Serial_ID )
SELECT root_SERV_CALL.MODEL, root_SERV_CALL.SERIAL
FROM root_SERV_CALL;

the fields in Table1 are setup exactly like the fields in root_SERV_CALL.

can some kind person shed some light on this for me or point me in the right
direction.

TIA

 

[Jerry Whittle]

What happens when you run the following:
SELECT root_SERV_CALL.MODEL, root_SERV_CALL.SERIAL
FROM root_SERV_CALL;

Are there any other fields in Table1 or a primary key / unique index?

Do either of the tables have the dreaded table-level lookup fields?

 

[Rick]

if i remove the INSERT statement, then the correct data is returned.
Table1 only has the 2 fields that i am trying to append date to.

rick