Format issue.?

[Steffe1611]

Hi.

I have run into a little problem I don´t understand.
I will compare two lists, but I don´t get the expected result.

I have two tables:
1. with 39 lines
2. with 7xx lines

I just want to find the matching "Lego part" in the two tables.
There is a match, but the data base says something different. Why.?

I have attached the database.

Please Help.

Steffen

 

[jdraw]

What exactly do you think should happen?
Can you give an example of what you want to happen?

 

[JHB]

You have a space in front of the numbers in table "T_wc_Free_Parts".

 

[Geotch]

Yes, the space is the problem. I uploaded a solution. I use the trim and mid functions.

The matches are in this query:
QryOffOfTrimmedTable

 

[Steffe1611]

Thanks Geotch

It works fine, but I have a little question.

How can this happen.? There were the space.?
All the data comes from the same table, just filtered in different queries and then put into the query you just solved.

I hope to learn a little.

Thanks.

Steffen

 

[Geotch]

Not sure how it happened in your case. I've had it happened over the years, just need to recognize an be able to fix. I usually send it back to my IT Dba guy and ask if their is something wrong with the view they are giving me and point out the space.