Cant find part

[YouMust]

I have 2 tables

INVENTORY_MSTR1
Stock Data

both have a part no: BF102864

If I run a query linking part number/s it doesnt show up in the list

I'm trying to run an update query where it queries the part number and then replaces a field (ABC_CODE) with the one from Stock Data.

what am I doing wrong?

I've imported INVENTORY_MSTR from a linked tabled, but still fails as a local table

 

[theDBguy]

Hi. Open up your inventory table and arrow down through your part number column. Do you notice the entire part number is highlighted but there's extra spaces also highlighted to the right? That means there are extra data in your field. So, that's why they are not matching with the data in the stock table.

 

[YouMust]

ah, I should of known!

Thanks DBguy

 

[theDBguy]

ah, I should of known!

Thanks DBguy

No biggie. Glad we could assist. Good luck with your project.

 

[YouMust]

I just get this to work with trim

In criteria I put =Trim([INVENTORY_MSTR1].[PART])

i get results but the above part is still missing -_-