Surely not the best way, but this worked for me - but it’s primarily useful as a one off:
Duplicate table (incl. “copy records”)Go to duplicated tableDuplicate the primary field - create a copy of itCopy the column with the records you want to search...