I need some help with a matching query in Access:
I have 2 tables: TableA and TableB which are not connected in the database. In TableA I have a column
ColumnA and want to find the closest values in ColumnB in Table B (not exact match).
I want the result of the query to display all values in ColumnA in one column and the closest values to each value in ColumnA in ColumnB in another column.
Thanks in advance!