I had this question after viewing disregard leading zero in query
Access 2010 vba
I have 2 tables:
table1 primary key MyKey1
SLS-002213-MAIN-A1 is an example value
table2 primary key MyKey2
SLS-002213 is an example value
So in order to get the join to work:
I just need the text in MyKey1 to be just 10 characters to match MyKey2 primary key.
But I agree.