I have a string that contains 5 digits (text & numbers).
I want to compare this string to a field in a linked table. This field has 7 digits, but I will only be comparing the last 5 to see if they match my string.
Once I find a matching record, I want to bring the data from just a few fields (out of many in the table) into strings.
I think that it may make sense to work from a query as most of the data in the table does me no good. From there, I have no idea how to properly search the table and how to return the data from there.
Please, any suggestions are appreciated!