Access 97

[Bruce]

I have two Tables in a database & I have made a Join between the Reference
fields.However, the data in the two Reference fields that I wish to find
duplicates for but the data is not an exact match e.g. 081/BW1 & BW1. I have
tried to use Like[Table Name].[Reference] but it won't work. How do I get
round this.

Thanks
Bruce

 

[John Spencer]

You have to use a non-equi join and that has to be entered in the SQL (text)
window.

SELECT ...
FROM TableA INNER JOIN Table2
ON TableA.RefField LIKE "*" & Table2.RefField
....