I dont get it....

[Simplycongy]

Been using simple access for a while now, and this problem is new on me...

Ive got two tables. One has data listed by OLD MATERIAL number (material) and the other has the new Material Number to convert to...

I wanted to simply add a column onto the table to show the new material number (just like a vlookup in excel)...

the odd thing is, i've done this loads of times before and tis worked... Anyone able to help??

SELECT [2005 DATA].*, MatConversion.[WDB Material], MatConversion.[wdb name], MatConversion.Category, MatConversion.Conversion
FROM [2005 DATA] LEFT JOIN MatConversion ON [2005 DATA].Mat = MatConversion.[Celtic material No];

 

[neileg]

Looks all right to me. How is it not working?