Find a text string and compare it against a field in a different t

J

janschutz

I have a long text string that contains a space two chars for a state and
then another space and I want to find that string and compare it to a field
in a different table. I have to group my data by that found state.
 
M

Michel Walsh

Using the operator like?


table1.SpaceTwoLettersSpaceSomethingElseField LIKE "*" &
table2.TwoLettersState & "*"



Hoping it may help,
Vanderghast, Access MVP


"[email protected]"
 
Top