Hi ,
I have this query and I obtain results from it.
I am trying to add another criteria to the same field. FieldName Like "*Word 1*" AND Like "*Word 2*" with out success.Code:SELECT FieldName FROM TableName WHERE FieldName Like "*Word 1*";
In other words I want to search for records with both criteria. The table represents the many side of a one-to-many relationship.
Any ideas ?
Khalil