Multiple Prompts

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

Guest

Is there a way to prompt the user for mulitple criteria for a query in Excel.
For instance, we want to prompt the user to enter a series of zipcodes and
use the list for the query.

Thank you.
 
Untested, but I would think You would concatenate a string of zipcodes into
an
sql string like below (partial)

v = "22032,63124,22334,55444"

.. . .

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

obviously you could prompt with in input box.
 
The input prompt did not recognize the entry. Thanks for the help, anway.
 
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 Criteria 1
Importing data from multiple Access queries 1
How pass credentials to Access from Excel (for onward use) 2
Access Auto Matching Duplicates? 0
Passing a Variable to a Macro 4
Can I pass the logon credentials in a macro to a ODBC query 1
Similar Book to Book Code, one works other does not 11
Counting multiple memberships 1

Back
Top