I have two tables, both containing tracking #. One is from FedEx and the other is generated from SQL. I need to match up the Tracking # from each table, however both of the tables fields have different preceding identifiers before the Tracking #, which are 14 charters long. I know in Excel I would just Right(14) and have matching data. But what is the statement I can use in Access?
Thanks for all help!
Thanks for all help!