"Rick Brandt" <ri*********@hotmail.comwrote in message
news:TU*******************@newssvr13.news.prodigy. net...
"ManningFan" <ma********@gmail.comwrote in message
news:11*********************@s48g2000cws.googlegro ups.com...
>Just like the title says.
I'm trying to do something like "Select * from table where somefield
in ('222', '333', '444')"
I'm pretty good at the Google but trying to search for the word "in"
is impossible. Anyone got an answer?
Yep. (why not try it and see what happens?)
Hold on now, I was responding to your message text and have just now noticed
your subject line. Do you want to do this in VBA or in a SELECT statement? It
will work in the latter, not the former. Unless you are constructing a SELECT
statement within a VBA routine in which case it will work fine.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com