First off I can’t change the source data or change the process my business uses.
I have two databases and I am trying to make a query that combines needed data from both into a nice excel sheet. I have some great success so far but I ran into a snag that I can’t solve. I need to match a number to another tables number. The issue is the number needs to be found in a cell with a bunch of other text. There will be multiple positive results but the second table with the text box has a separate column with dates.