Joins

[jlgray0127]

I have a table from an data warehouse that I am trying to tie to an access database I created.
The fields I am trying to do the join in, it's kinda difficult...
In the data warehouse, the field, say ID, represents 10 characters, including spaces... it's always 10, though.
The value could be 1234568, 123456, or 1234567890. If there are only 5 characters, the other 5 characters are blank spaces.
The table I am entering the data into, in my database, the values are not led off with blanks. We input 1234568, and it is only 7 characters.
How can I make the two fields recognize eachother based on the Right characters. I never know how many "actual" characters there are.

[hertfordkc]

Check out the Replace function, i.e. replace the " " in the warehouse id with "".

[TheShabz]

Trim() would also work for you. It will also be independent of how many leading or trailing spaces you have. It just gets rid of all of them.