Making the like operator work for fields

[olidav911]

Hi I am trying to compare two fields in different tables and I need to do a like because it is searching for specific characters in the whole field. I've got - like "*[tablename].[fieldname]*". Unfortunately the " marks will make it look for whatever is inside it rather than in the table itself. Does anybody know a way round this? I hope I've made myself clear!

[RuralGuy]

To start with you can not just qualify a field with a table name and expect anything useful to happen in Access. You need a RecordSet for the [TableName] and pull the [FieldName] into a variable so you can search with the Like operator and wild cards.l

[thhui]

You have to set the criteria below instead:-

Like '*' & [TableName].[FieldName] & '*'