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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Using the operator like?


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



Hoping it may help,
Vanderghast, Access MVP


"(e-mail address removed)"
 
Back
Top