So I have two queries with multiple rows and I'm trying to compare the rows from TablesCells to TablesTemplate to make sure their columns are the same. Occasionally TablesCells may have an input where in Templates its null and vice versa.
I was hoping that the TableBuster query would show the...
I'm new to access and ive been running around trying to figure out this. I can bring in data with one query from two columns that will look like this below. I need to make sure that the MP01A in column 1 matches MP01A in column2 while ignoring the - in the comparison. If it matches the...