Cant find part (1 Viewer)

Y

YouMust

Registered User.

Local time

Today, 15:05

Joined

May 4, 2016

Messages

106

• Nov 21, 2019

• #1

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

 

Attachments

• ABC_CODE.accdb

  760 KB · Views: 96

theDBguy

I’m here to help

Staff member

Local time

Today, 15:05

Joined

Oct 29, 2018

Messages

21,467

• Nov 21, 2019

• #2

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.

 

Y

YouMust

Registered User.

Local time

Today, 15:05

Joined

May 4, 2016

Messages

106

• Nov 21, 2019

• #3

ah, I should of known!

Thanks DBguy

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:05

Joined

Oct 29, 2018

Messages

21,467

• Nov 21, 2019

• #4

YouMust said:

ah, I should of known!

Thanks DBguy

Click to expand...

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

 

Y

YouMust

Registered User.

Local time

Today, 15:05

Joined

May 4, 2016

Messages

106

• Nov 25, 2019

• #5

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 -_-