hello everyone! hope someone can help me out.
i have a query that does a search for a string in 1 field right now in the table. it works great, but then i found out that the string may also appear in another field.
for example, my query looks for "abc" in Field 1. then i found out i also want to search for "abc" in Field 2. In Field 1 and Field 2 there's no way to tell where the string will appear. Field 1 and Field 2 are text fields too. So I was thinking it should be a Like "*" & abc & "*" type match.
so basically i want a query that will return results if "abc" is in Field 1 or Field 2.
Is there a way to build this?
i have a query that does a search for a string in 1 field right now in the table. it works great, but then i found out that the string may also appear in another field.
for example, my query looks for "abc" in Field 1. then i found out i also want to search for "abc" in Field 2. In Field 1 and Field 2 there's no way to tell where the string will appear. Field 1 and Field 2 are text fields too. So I was thinking it should be a Like "*" & abc & "*" type match.
so basically i want a query that will return results if "abc" is in Field 1 or Field 2.
Is there a way to build this?
