Sorry, if I am doing this incorrectly, however if anyone can help me that would be appreciated. I have two tables with sets of data that I need to match up with a query. Table one contains all of the data, and the field i need to match to has a string of alphanumeric characters where the number i am seeking is embedded at the beginning and it is not a set length. Table two contains the data I am seeking, however I cannot write a query to match them.
example:
table 1 column2 table 2 column 3
122frs34812489481348 10001
22efwee1974516484 1246884
10001549841818188 122
12468842574818418 22
i need to get a result where i can find record 10001 (first record in table 2) in table one in the long string (in this example it will be record 3). Don't laugh but i tried using something such as like "[table2].[field]*" but i guess its been too long since I've used my access knowledge.
Thanks