Truncating characters in a field

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have to import a spreadsheet that has numbers formatted as characters to
allow for keeping the leading zeros (003 vs 3). I will then have to take a
value from another table, storing a 7 character string and for some eliminate
the first 3 positions of that string, or the first position of that string.
This will be used in a query to look up another value in anther table.
 
I have to import a spreadsheet that has numbers formatted as characters to
allow for keeping the leading zeros (003 vs 3).  I will then have to take a
value from another table, storing a 7 character string and for some eliminate
the first 3 positions of that string, or the first position of that string.  
This will be used in a query to look up another value in anther table.  
Click to expand...

or you could use a join in your query.

SELECT...
FROM tblA INNER JOIN tblB ON RIGHT$(tblA.Field1,4)=tblB.Field2
 
Back
Top