Joining Tables with Added Spaces in Field

[jvleigh221]

In joining two tables in a query I'm running into a problem.

In the main table, the field entry is normal. For example Table1.ID = "ID_104"

However in the Table I'm Left Joining the Feild entry has trailing spaces, Table2.ID = "ID_104 "

When I try to join the two and run the query I get an Invalid Operation. I'm guessing due to the fact that they do not match up because of the trailing spaces.

How can I get the two tables to join properly?

Thanks.
Jeremy

 

[Remou]

I do not think that it is the spaces. Can you post the SQL and the error messages, please?

 

[jvleigh221]

I simplified it best I can:

SELECT [qryORIGINAL].CTRL_NBR, INV_ITEM.GSTYLE, INV_STYLE.ECK_US_ECCN
FROM ([qryORIGINAL] LEFT JOIN INV_ITEM ON [qryORIGINAL].ITEM_NBR = INV_ITEM.ITEM_NBR) LEFT JOIN INV_STYLE ON INV_ITEM.GSTYLE = INV_STYLE.STYLE;

The Query referenced above pulls from the database table all records pertaining to a specific CTRL_NBR.

The error I get is "Invalid Operation"

Thanks,
Jeremy

 

[Remou]

Have you tried the query in its simplified form? Does it return the same error?