Thread: Multiple Criteria

Is there a way to prompt the user for a number of entries to use as the
criteria for an excel query: we want to prompt the user for a number of
zipcodes (not in series) to use as the query selection.

Untested, but I would think You would cocatenate a sting of zipcodes into an
sql string like below (partial)
v = "22032,63124,22334,55444"

.. . .

" . . . where tablename.zip In (" & v & "), . . . "

--
Regards,
Tom Ogilvy


"jberv534" wrote:

> Is there a way to prompt the user for a number of entries to use as the
> criteria for an excel query: we want to prompt the user for a number of
> zipcodes (not in series) to use as the query selection.