we need just like the following, only with multiple records selected... have tried the "xyz" in (1,2,3,4,5) SQL code but of course VB Script wants something else.
dim f2
if [field1] = "foo" then
f2 = "bar"
end if
Screen shot of this being used in the field calculator.alt text