Multiple Criteria

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

Guest

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 & "), . . . "
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Prompts 3
Access Dcount (multiple criteria) 3
Access Auto Matching Duplicates? 0
Counting multiple memberships 1
Count cells containing text, multiple criteria 2
VB to specify criteria then paste to a new worksheet 1
VBA: How can I use a string variable as autofilter criteria? 4
remembering the same filtering criteria 13

Back
Top