Search results

After thinking about it I came up to that conculsion but I am running into issue with the function I am writing. I get matches on everything and am not sure what is off. If Left(SupplyLocation, 2) = Left(DemandLocation, 2) Or Left(SupplyLocation, 2) = Mid(DemandLocation, 5, 2) Or...

Hello I need some help. I have two fields in a table that have multiple values. Example: Field A: CT, CA, PA Field B: CT, CA I want to compare the two fields and indicate that there is a match because in this example CT and CA are in both fields. I would like to create a function. I'm not...