Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i would like to join two field (materialno) .
The first loaded table has values with 12345,23456 and the second table has 000000000000012345 or 000000000009012345
Table 1 5-digit
Table 2 18-digit.
How can I change it ? Many thanks in advance.
Thank you for fast answer.
How to do this when the second table has also values with 8 digit?
If the identifier in the second field is always last five numbers you can do it like this:
Right(Field2,5) as Field2
Make sure that both fields have the same name when joining
Thank you for fast answer.
How to do this when the second table has also values with 8 digit?
If the identifier is always 5 digits it doesn't matter. The function always takes last 5 numbers
now I understand Thanks 🙂