Bill - I use this all of the time. It's a super-fast search technique....hugely beating looping. > > Sometimes I string all the values together pipe separated, and say > where > '|LONG|LIST|OF|FIELD|VALUES|' Like "*|" & [MyField] & "|* >