can i force join even with data type mismatch?
Posted on 2011-10-25
i have an access table with an autonumber field used to identify our parts.
we export this list and send it to our customers for them to place orders with us.
when we receive their orders via text file, we import it into access and our original autonumber is now a text field instead of a number field.
i want to join our table to their orders and join our autonumber field with the corresponding incoming text field in order to easily match part numbers and pricing, etc...
but since it's a different data type i keep getting the error.
how can i join our number field with the text field?