Type mismatch in expression???

[sasolini]

hey,

can someone pls tell me why i get an Type mismatch in expression err with this code:

INSERT INTO tblACAD ( PROIZVAJALEC, TIP, DN, KOSOV )
SELECT tblsifrant.Proizvajalec, tblsifrant.Tip, tblsifrant.DN, tblsifrant.Kosov
FROM tblsifrant, tblACAD
WHERE (((tblsifrant.Sifra)=[tblACAD.TIP]) AND ((tblsifrant.DN)=[tblACAD.DN]) AND ((tblACAD.KOSOV)>0));

If i remove one criteria to get this code then there are no err, but thats not what i want:

INSERT INTO tblACAD ( PROIZVAJALEC, TIP, DN, KOSOV )
SELECT tblsifrant.Proizvajalec, tblsifrant.Tip, tblsifrant.DN, tblsifrant.Kosov
FROM tblsifrant, tblACAD
WHERE (((tblsifrant.Sifra)=[tblACAD.TIP]) AND ((tblACAD.KOSOV)>0));

I create this code in design view so all the names and tables are correct.

So does anyone have any ideas?

Thx

 

[Jibbadiah]

((tblsifrant.DN)=[tblACAD.DN]) ... is it possible that DN is a different format in each table, i.e. text vs number. If so make them the same.

 

[sasolini]

thx for that...its ok now