Data Mismatch Error

[kabir_hussein]

data mismatch error

hi I am using the following code to link two tables(update one from to other) but i get the follwoing message.

DATA MISMATCH ERROR

however i am sure everything is right

what could be wrong

thank you

here is the code i am using

INSERT INTO tenderlink ( TenderlinkID, [Tender Quantity], [Tender Unit Price], [Target Unit Price], [Tender Cost] )
SELECT Changelink.tenderlinkID, Changelink.[Tender Qty Changed], Changelink.[Tender Unit Price Changed], Changelink.[Target Unit Price Changed], Changelink.[Tender Cost Changed]
FROM Changelink left JOIN tenderlink ON ([tenderlink].[TenderlinkID] = [changelink].[tenderlinkID])

 

[jeremie_ingram]

DATA MISMATCH ERROR means that you are trying to put one data type into a field that requires another. An example would be puting text into a number field.
Open both tables in design view and make sure the FIESLD TYPES match, but if you have an AUTO NUMBER, make sure it updates to a NUMBER field. You run into problems when you try to import data into an autonum field.

 

[kabir_hussein]

cheers

i have sorted that now thanks alot